Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
having trouble creating chart to show monthly totals | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |