chart formatted data point

[Pippa M]

I have formatted an individual data point however when I sort my data the
formatting stays in the same place. I need to be able to link the formatting
to a particaulr X axis reference - such as in benchmarking where the data may
change month on month but we are only interested in our practice.

 

[Andy Pope]

Hi,

Have a look at this conditional chart technique, which uses additional
series to hi-lite individual points in a series,
http://peltiertech.com/Excel/Charts/PointAtPoints.html

Cheers
Andy