Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Maria
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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
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
Charts not recognizing source data if original linked data is changed. JLC Charts and Charting in Excel 3 October 14th 05 01:29 AM
In a 2 Y-Axis chart, how do I assign data ranges to an axis? Claire4Golf Charts and Charting in Excel 1 September 28th 05 07:52 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
How do I group data using defined ranges? Yenabi Excel Worksheet Functions 2 May 16th 05 06:33 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 02:01 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"