Create multiple data series for a chart in one shot...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to create a scatter chart and enter about 100 data series (a
name, x value, y value for each). I could do it manually but I'm sure
there's a more efficient way. Can you help?

Thanks!

Ron
 
Hi,

Do you really need the points to be separate series?

Perhaps you can create a xy scatter on the x and y data and then use of
these free addin to link your data labels to the names.

Rob Bovey's Chart Labeler
http://appspro.com

Or John Walkenbach's Chart Tools
http://j-walk.com

Cheers
Andy
 
Thanks for the response and advice.

I actually inherited a file (at work), where a large amount of series were
entered in at once, and been asked to replicate the feat. Is there an
organic way to do so in Excel, or are the add-ins the only option?

Thanks again!

Ron
 
Maybe you could write your own code to update and or create the chart.

What do you mean by 'organic way'?

Cheers
Andy
 
Back
Top