If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Charts which automatically adapt to variable source data length | Excel Engineer | Charts and Charting | 1 | August 15th, 2004 12:47 PM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |