Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 65
Default How do I compare data across series and categories in the same gra

I have 2 categories of data - production & consumption of energy. within
these categories, the data is further broken down into the energy source (eg.
oil, gas etc).

I want to graph the data in such a way that production and consumption
totals are plotted as a time series, with each one showing the contribution
from the specific energy sources.

Is this possible with any of the default graph types? If yes, which one? If
not, can I create a custom graph type? how?

Thank you, in advance, for any inputs, advice, suggestions etc.
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
Secondary y-axis for certain x-axis categories (not by series) SonzAMonz Charts and Charting in Excel 2 June 19th 07 01:33 PM
How can I make categories out of my data? NoviceinEXCEL Excel Worksheet Functions 3 December 7th 06 06:12 PM
Series Categories not in order Kim Charts and Charting in Excel 0 July 19th 06 09:36 AM
How can I create a chart to compare multiple data series? magnoliak77 Charts and Charting in Excel 2 July 2nd 06 02:01 AM
How can I collapse Excel data into categories? mschargerfan Excel Discussion (Misc queries) 2 May 10th 06 01:04 PM


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