View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
viv viv is offline
external usenet poster
 
Posts: 14
Default 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