chart trouble

[chilegrowr]

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

 

[Jon Peltier]

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]

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!

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/
_______

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

 

[Jon Peltier]

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

- Jon

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!

:

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