ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I compare data across series and categories in the same gra (https://www.excelbanter.com/charts-charting-excel/167143-how-do-i-compare-data-across-series-categories-same-gra.html)

kiran

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.


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com