Multiple series in a scatter chart
Hi,
A colleague of mine is trying to set up a scatter graph with multiple series
as follows:
A 10% £20,000
B 15% £15,000
C 12.5% £16,000
etc....
He wants the scatter graph to have a key for each series.
I can't find a way of doing this by selecting a data range. I've been able
to do this by adding each series individually, but as there are a large
number of series this will take some time.
Has anyone got any suggestions? I hate it when Excel beats me!
Thanks
--
Viv
|