How to reorder data points on a graph?
 

Hi,

I need to anonymise data points on a graph (currently ordered
alaphabetically) and I have done this by amending the name of each point at
source. However, although the graph now shows the anonymised data in the
axis, all the data points are effectively still in alaphabetical order so it
is easy to work out who is who.

I know it's possible to reorder data points in some instances onm the graph
itself by clicking on the data point and going to OptionsReorder Series but
this option doesn't appear to be selected for many of my graphs?

Any help much appreciated!

R

How to reorder data points on a graph?
 

Sort the data by the anonymized names.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"kippers" wrote in message
...
Hi,

I need to anonymise data points on a graph (currently ordered
alaphabetically) and I have done this by amending the name of each point
at
source. However, although the graph now shows the anonymised data in the
axis, all the data points are effectively still in alaphabetical order so
it
is easy to work out who is who.

I know it's possible to reorder data points in some instances onm the
graph
itself by clicking on the data point and going to OptionsReorder Series
but
this option doesn't appear to be selected for many of my graphs?

Any help much appreciated!

R