View original (French)

Remove a point from an Excel chart

erickvand -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   -
Hello,

I would like to delete a point in a scatter plot connected with lines in Excel. The problem is that when I click on a point, it also selects the point just before it, and then if I want to delete one, it deletes the whole graph.

So, how can I select just one point in the graph and delete it without deleting the entire graph?

P.S.: It would be great if someone also had an idea on how to code this in VB.

Thanks in advance.
Configuration: Windows XP Internet Explorer 6.0

2 réponses

Réponse 1 / 2
hich24 Posted messages 1686 Status Membre 753
 
remove from the given table the value associated with this point
0
erickvand
 
Thank you, but I had thought about it.
I don't want to delete the values, but just the dot without deleting the graph.
So how do we do that?

Thank you in advance.
0
Réponse 2 / 2
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
"" How do we do that then? "
Difficult to imagine: The graph is the faithful representation of the pairs of points selected in the table.
There is no way to act directly on the graph, which is the result of the operation.
All you can do, and I highly recommend it, is to hide the row in the table corresponding to the point that interests you.
--
Retirement is great! Especially in the Antilles... :-)
☻ Raymond ♂
-2