Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 08, 07:28 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 1
Default Adding multiple series to charts

My, the sign-on process was annoying! I had to click "allow this" 12 times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart? It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data to
the and want them to appear on the chart, the only way I've found to do this
is to right click, choose "select data", "add" and then individually enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time, why is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me use
Excel.

  #2   Report Post  
Old June 1st 08, 02:29 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 16
Default Adding multiple series to charts

1. click somewhere on your chart, but not on a specific object - the data
source of your chart will get highlighted
2. hover your mouse on the corner of the frame that delimitates the data range
3. adjust the size of the data range

Now this only works, if the new columns and the previous ones build a range.

"Steven K. Smith" wrote:

My, the sign-on process was annoying! I had to click "allow this" 12 times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart? It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data to
the and want them to appear on the chart, the only way I've found to do this
is to right click, choose "select data", "add" and then individually enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time, why is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me use
Excel.

  #4   Report Post  
Old June 2nd 08, 02:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 6
Default Adding multiple series to charts

Most of the charts I make, and the specific one where the question came up,
are in a seperate sheet, not embeded in a worksheet. Also, the usual case
seem to be that "The chart range is too complex to display..." on my charts.
When I tried this on another spreadsheet with an embeded chart, it didn't
highlight the data ranges.


--
I speak for truth, enlightenment and justice, but not for the US Air Force.



"Laurent" wrote:

1. click somewhere on your chart, but not on a specific object - the data
source of your chart will get highlighted
2. hover your mouse on the corner of the frame that delimitates the data range
3. adjust the size of the data range

Now this only works, if the new columns and the previous ones build a range.

"Steven K. Smith" wrote:

My, the sign-on process was annoying! I had to click "allow this" 12 times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart? It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data to
the and want them to appear on the chart, the only way I've found to do this
is to right click, choose "select data", "add" and then individually enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time, why is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me use
Excel.

  #5   Report Post  
Old June 2nd 08, 02:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 6
Default Adding multiple series to charts

Sorry, I thought at first it didn't work correctly, but then I realized I was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line chart, it
simply puts the selected data at the beginning of the chart, regardless of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote in
message ...
My, the sign-on process was annoying! I had to click "allow this" 12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data to
the and want them to appear on the chart, the only way I've found to do
this
is to right click, choose "select data", "add" and then individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time, why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me use
Excel.






  #6   Report Post  
Old June 2nd 08, 04:33 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Adding multiple series to charts

In a line chart, all series use the category values defined for the first
series. If you want two series to use different X values, you need to
provide all X values, with gaps where either series has no corresponding Y
values. The data looks like this, select the entire range, including blanks,
and make the chart.

X Y1 Y2
1 2
2 3
3 4
4 5
5 3
6 4
7 5
8 6

If the two series overlap, arrange like so, and go to Tools menu Options
Chart Tab, and choose Interpolate for how Excel should deal with empty
cells.

X Y1 Y2
1 2
2 3
3 3
4 4
5 4
6 5
7 5
8 6

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


"Steven K. Smith" wrote in message
...
Sorry, I thought at first it didn't work correctly, but then I realized I
was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line chart, it
simply puts the selected data at the beginning of the chart, regardless of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air
Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote in
message ...
My, the sign-on process was annoying! I had to click "allow this" 12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data
to
the and want them to appear on the chart, the only way I've found to do
this
is to right click, choose "select data", "add" and then individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time,
why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me
use
Excel.






  #7   Report Post  
Old July 28th 08, 08:49 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 5
Default Adding multiple series to charts

How do I add lots of series? I need to plot data for up to 1000 series in a
single chart, with each series representing a single customer.

I'm basically trying to graph buying behavior of customers, where I map lots
of customer purchases on a chart to see what trends pop out.

So my data might look like this:

Customer Days Widgets
A 1 1000
A 300 3000
B 200 200
B 1000 10000

So customer A bought 1000 widgets on Day 1 and 3000 widgets on Day 300.
Customer B bought 200 widgets on Day 200, and so on.

The challenge is that I don't know how many customers I will be graphing,
and each customer may buy on a different day.

"Jon Peltier" wrote:

In a line chart, all series use the category values defined for the first
series. If you want two series to use different X values, you need to
provide all X values, with gaps where either series has no corresponding Y
values. The data looks like this, select the entire range, including blanks,
and make the chart.

X Y1 Y2
1 2
2 3
3 4
4 5
5 3
6 4
7 5
8 6

If the two series overlap, arrange like so, and go to Tools menu Options
Chart Tab, and choose Interpolate for how Excel should deal with empty
cells.

X Y1 Y2
1 2
2 3
3 3
4 4
5 4
6 5
7 5
8 6

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


"Steven K. Smith" wrote in message
...
Sorry, I thought at first it didn't work correctly, but then I realized I
was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line chart, it
simply puts the selected data at the beginning of the chart, regardless of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air
Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote in
message ...
My, the sign-on process was annoying! I had to click "allow this" 12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of data
to
the and want them to appear on the chart, the only way I've found to do
this
is to right click, choose "select data", "add" and then individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time,
why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me
use
Excel.






  #8   Report Post  
Old July 28th 08, 09:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Adding multiple series to charts

An Excel chart is limited to 255 series. You need to rethink what you want
to chart. Does each customer need its own series? Are you interested in
widgets per day, cumulative widgets, or something else?

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


"rparker" wrote in message
...
How do I add lots of series? I need to plot data for up to 1000 series in
a
single chart, with each series representing a single customer.

I'm basically trying to graph buying behavior of customers, where I map
lots
of customer purchases on a chart to see what trends pop out.

So my data might look like this:

Customer Days Widgets
A 1 1000
A 300 3000
B 200 200
B 1000 10000

So customer A bought 1000 widgets on Day 1 and 3000 widgets on Day 300.
Customer B bought 200 widgets on Day 200, and so on.

The challenge is that I don't know how many customers I will be graphing,
and each customer may buy on a different day.

"Jon Peltier" wrote:

In a line chart, all series use the category values defined for the first
series. If you want two series to use different X values, you need to
provide all X values, with gaps where either series has no corresponding
Y
values. The data looks like this, select the entire range, including
blanks,
and make the chart.

X Y1 Y2
1 2
2 3
3 4
4 5
5 3
6 4
7 5
8 6

If the two series overlap, arrange like so, and go to Tools menu
Options
Chart Tab, and choose Interpolate for how Excel should deal with empty
cells.

X Y1 Y2
1 2
2 3
3 3
4 4
5 4
6 5
7 5
8 6

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


"Steven K. Smith" wrote in
message
...
Sorry, I thought at first it didn't work correctly, but then I realized
I
was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line chart,
it
simply puts the selected data at the beginning of the chart, regardless
of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air
Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use
Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote in
message ...
My, the sign-on process was annoying! I had to click "allow this"
12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter
chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of
data
to
the and want them to appear on the chart, the only way I've found to
do
this
is to right click, choose "select data", "add" and then
individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time,
why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me
use
Excel.








  #9   Report Post  
Old July 29th 08, 04:32 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 5
Default Adding multiple series to charts

You raise some valid points. I can probably get each chart down to 255
stages by breaking out customers by geographic region, customer size, etc.

If I can do this, then what is the most effective way to graph out all the
customer series? I was looking on your Web site for an example but couldn't
find anything that jumped out at me. Could I do this with a Series Formula?

"Jon Peltier" wrote:

An Excel chart is limited to 255 series. You need to rethink what you want
to chart. Does each customer need its own series? Are you interested in
widgets per day, cumulative widgets, or something else?

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


"rparker" wrote in message
...
How do I add lots of series? I need to plot data for up to 1000 series in
a
single chart, with each series representing a single customer.

I'm basically trying to graph buying behavior of customers, where I map
lots
of customer purchases on a chart to see what trends pop out.

So my data might look like this:

Customer Days Widgets
A 1 1000
A 300 3000
B 200 200
B 1000 10000

So customer A bought 1000 widgets on Day 1 and 3000 widgets on Day 300.
Customer B bought 200 widgets on Day 200, and so on.

The challenge is that I don't know how many customers I will be graphing,
and each customer may buy on a different day.

"Jon Peltier" wrote:

In a line chart, all series use the category values defined for the first
series. If you want two series to use different X values, you need to
provide all X values, with gaps where either series has no corresponding
Y
values. The data looks like this, select the entire range, including
blanks,
and make the chart.

X Y1 Y2
1 2
2 3
3 4
4 5
5 3
6 4
7 5
8 6

If the two series overlap, arrange like so, and go to Tools menu
Options
Chart Tab, and choose Interpolate for how Excel should deal with empty
cells.

X Y1 Y2
1 2
2 3
3 3
4 4
5 4
6 5
7 5
8 6

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


"Steven K. Smith" wrote in
message
...
Sorry, I thought at first it didn't work correctly, but then I realized
I
was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line chart,
it
simply puts the selected data at the beginning of the chart, regardless
of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air
Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use
Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote in
message ...
My, the sign-on process was annoying! I had to click "allow this"
12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter
chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns of
data
to
the and want them to appear on the chart, the only way I've found to
do
this
is to right click, choose "select data", "add" and then
individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one time,
why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes me
use
Excel.









  #10   Report Post  
Old July 29th 08, 01:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Adding multiple series to charts

It depends on what you want to show. As I asked...

Does each customer need its own series? Are you interested in
widgets per day, cumulative widgets, or something else?


Another thing you need is legibility, but your posts don't indicate that
you're too concerned with that.

What you need to think about includes:

* do I understand my client?
- do I understand the data?
- do I understand what they need to learn from the chart?
- do I know how they currently display the data?
* what are my plotted values?
* how do I segment the data?
- what are the categories? dates? parts? customer? something else?
- how do I define my series? customer? part number? classifications of
parts?

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



"rparker" wrote in message
...
You raise some valid points. I can probably get each chart down to 255
stages by breaking out customers by geographic region, customer size, etc.

If I can do this, then what is the most effective way to graph out all the
customer series? I was looking on your Web site for an example but
couldn't
find anything that jumped out at me. Could I do this with a Series
Formula?

"Jon Peltier" wrote:

An Excel chart is limited to 255 series. You need to rethink what you
want
to chart. Does each customer need its own series? Are you interested in
widgets per day, cumulative widgets, or something else?

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


"rparker" wrote in message
...
How do I add lots of series? I need to plot data for up to 1000 series
in
a
single chart, with each series representing a single customer.

I'm basically trying to graph buying behavior of customers, where I map
lots
of customer purchases on a chart to see what trends pop out.

So my data might look like this:

Customer Days Widgets
A 1 1000
A 300 3000
B 200 200
B 1000 10000

So customer A bought 1000 widgets on Day 1 and 3000 widgets on Day 300.
Customer B bought 200 widgets on Day 200, and so on.

The challenge is that I don't know how many customers I will be
graphing,
and each customer may buy on a different day.

"Jon Peltier" wrote:

In a line chart, all series use the category values defined for the
first
series. If you want two series to use different X values, you need to
provide all X values, with gaps where either series has no
corresponding
Y
values. The data looks like this, select the entire range, including
blanks,
and make the chart.

X Y1 Y2
1 2
2 3
3 4
4 5
5 3
6 4
7 5
8 6

If the two series overlap, arrange like so, and go to Tools menu
Options
Chart Tab, and choose Interpolate for how Excel should deal with empty
cells.

X Y1 Y2
1 2
2 3
3 3
4 4
5 4
6 5
7 5
8 6

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


"Steven K. Smith" wrote in
message
...
Sorry, I thought at first it didn't work correctly, but then I
realized
I
was
testing this on a "line" chart rather than an XY chart.

Your suggestion works well for XY, but if you try it on a line
chart,
it
simply puts the selected data at the beginning of the chart,
regardless
of
where the data you'd selected occured in the original chart.

Thanks for the help.


--
I speak for truth, enlightenment and justice, but not for the US Air
Force.



"Jon Peltier" wrote:

Copy the range of data you want to add, select the chart, and use
Paste
Special to add the data as new series.

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


"Steven K. Smith" <Steven K. wrote
in
message ...
My, the sign-on process was annoying! I had to click "allow
this"
12
times
after I started counting, just so I could ask this question.

In Excel 2007, how do I add multiple series of data to a scatter
chart?
It
appears to only allow you to add one series at a time.

I have a worksheet with data in columns. If I add some columns
of
data
to
the and want them to appear on the chart, the only way I've found
to
do
this
is to right click, choose "select data", "add" and then
individually
enter
the X and Y ranges for each series, one at a time.

It has no problem creating a chart with multiple series at one
time,
why
is
this different? This was much easier in Excel 2003.

Sooooo annoying, but until I can dump this job my workplace makes
me
use
Excel.













Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts switch from 'Series in Rows' to 'Series in Columns' Peace Charts and Charting in Excel 4 March 22nd 07 04:52 AM
XY Scatter Charts, High/Low bars, Multiple Series Kevin M. Charts and Charting in Excel 1 May 1st 06 10:16 PM
How do I plot multiple x-axis series in excel charts bdorr Charts and Charting in Excel 2 November 23rd 05 03:21 PM
Disappearing scales on bar charts with multiple series Patrick Charts and Charting in Excel 3 November 3rd 05 10:10 PM
Charts Line Types for Multiple Data Series not Printing Properly Seanb Charts and Charting in Excel 0 August 22nd 05 06:35 PM


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017