How to create a moving point (intermittently) on on a graph?

[readyt]

I currently have some price data which is updated everyday and monitored on a graph.


I have a formula set up so whenever the price reaches its lowest to date it turns green so it is easy to identify in the table.


I would like to plot a point on the graph that is 10% above this value, so whenever a new low point is reached it will show up on the graph as a 'x'.


How can i do this without plotting all the other points?


Thanks

 

[Hui]

Readyt


Firstly, Welcome to the Chandoo.org forums.


Have a look at this post: http://chandoo.org/wp/2010/11/11/highlight-data-points-scatter-line-charts/

 

[Montrey]

Create a new series.

For any point you do not want displayed enter a #N/A

Create a formula that will populate the cell point you need when ur criteria is met.

Format the series accordingly.