View original (French)

Remove a point from an Excel chart

erickvand -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor 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 answers

  1.
    hich24 Posted messages 1686 Status Member 753
     
    remove from the given table the value associated with this point
    0
    1. 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
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    "" 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