A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple series in a scatter chart



 
 
Thread Tools Display Modes
  #11  
Old October 16th, 2009, 05:24 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Source data for multiple series in scatter chart

Do you really need 100 series? If your data is like this, three columns,
make an XY chart with the second and third columns, then use Rob Bovey's
Chart Labeler add-in (http://appspro.com) to apply the labels in the
first column to the points.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



kolkova wrote:
Hi, I've been struggling with a similar issue. I've created an xy scatter chart which has over 100 series. A sample:

Series Name X Value Y Value
Mark 1 2
John 3 1
Matt 4 2
etc etc

In "source data" excel does not automatically picks u the "x value" and "y value" from the correct cell. How can I point it to the right place without having to change this manually for each of the 100 series? Thanks!





Jon Peltier wrote:

Multiple series in a scatter chart
20-Sep-07

I've written short VBA procedures that will create a chart with one point
per series (google for my name and sthg like "onepointperseries"), but these
charts lose their effectiveness as the number of series exceeds a dozen. To
eliminate the user having to go back and forth between the chart and the
legend to decipher the markers and colors, you add labels, and if you do
this, you may as well make a single series with labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David Biddulph" groups [at] biddulph.org.uk wrote in message
...

Previous Posts In This Thread:

On 20 September 2007 05:28
Vi wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.