Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 DATA RANGES IN CHARTS
I am trying to create a chart of stacked data
The data I have is Class of cost Planned and Actual by month/year I want a chart that will show me actuals by class of cost and then side by side actual and planned I am not sure if i can create a chart that will range two data series. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 DATA RANGES IN CHARTS
If you arrange your data properly, a lot of things in Excel are vastly
simplified. To chart multiple series, put the category labels (or X values) into a column, put the Y values for one series into the column to the right, and put Y values for any additional series in the next columns after that. If the data is already arranged in arbitrary locations on the sheet, you can make the chart with one series, then on the Chart menu, choose Source Data, then click on the Series tab, then click Add, and add as many series as you need, selecting data ranges for their X and Y data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Maria" wrote in message ... I am trying to create a chart of stacked data The data I have is Class of cost Planned and Actual by month/year I want a chart that will show me actuals by class of cost and then side by side actual and planned I am not sure if i can create a chart that will range two data series. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
How do I group data using defined ranges? | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |