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.

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Pippa M" <Pippa wrote in message
...
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.