#1   Report Post  
chilegrowr
 
Posts: n/a
Default chart trouble

I'm making a simple chart, with 2 series with 2 data points in each series,
but only the first set of data points are graphed
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Are you making an XY chart? Excel might be using the first series as the
X values for the second series. Try this kind of data arrangement:

Srs-a Srs-b
X1 Y1a Y1b
X2 Y2a Y2b

Srs-a and Srs-b are the series names (legend entries) for the two
series, and you are explicitly providing X values for both series in the
first column. Select this 3x3 range, run the chart wizard, and in step
2, make sure the series are in columns.

[BTW, shouldn't that be chiligrowr?]

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


chilegrowr wrote:

I'm making a simple chart, with 2 series with 2 data points in each series,
but only the first set of data points are graphed

  #3   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

did you choose <series in the source data window
and then add one by one the series
easy to do is click on an empty cell and hit F11.
in the chart sheet right click and click <sourcedata
and choose <seris

there may be other ways of doing this.

--
remove $$$ from email addresss to send email
===========
"chilegrowr" wrote in message
...
I'm making a simple chart, with 2 series with 2 data points in each

series,
but only the first set of data points are graphed



  #4   Report Post  
chilegrowr
 
Posts: n/a
Default

thanks, i'll give it a go in the morning. btw: "chili" is that meat and
chiles and tomatoes stuff in a can at the supermarket!

"Jon Peltier" wrote:

Are you making an XY chart? Excel might be using the first series as the
X values for the second series. Try this kind of data arrangement:

Srs-a Srs-b
X1 Y1a Y1b
X2 Y2a Y2b

Srs-a and Srs-b are the series names (legend entries) for the two
series, and you are explicitly providing X values for both series in the
first column. Select this 3x3 range, run the chart wizard, and in step
2, make sure the series are in columns.

[BTW, shouldn't that be chiligrowr?]

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


chilegrowr wrote:

I'm making a simple chart, with 2 series with 2 data points in each series,
but only the first set of data points are graphed


  #5   Report Post  
Jon Peltier
 
Posts: n/a
Default

I thought chilis were the peppers, and Chile was the country.

- Jon

chilegrowr wrote:

thanks, i'll give it a go in the morning. btw: "chili" is that meat and
chiles and tomatoes stuff in a can at the supermarket!

"Jon Peltier" wrote:


Are you making an XY chart? Excel might be using the first series as the
X values for the second series. Try this kind of data arrangement:

Srs-a Srs-b
X1 Y1a Y1b
X2 Y2a Y2b

Srs-a and Srs-b are the series names (legend entries) for the two
series, and you are explicitly providing X values for both series in the
first column. Select this 3x3 range, run the chart wizard, and in step
2, make sure the series are in columns.

[BTW, shouldn't that be chiligrowr?]

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


chilegrowr wrote:


I'm making a simple chart, with 2 series with 2 data points in each series,
but only the first set of data points are graphed


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
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
having trouble creating chart to show monthly totals Ian Roberts Charts and Charting in Excel 2 June 5th 05 06:36 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 05:09 AM.

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

About Us

"It's about Microsoft Excel"