ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Create a custom chart, two stacked bars/month w/ two axes? (https://www.excelbanter.com/charts-charting-excel/18531-create-custom-chart-two-stacked-bars-month-w-two-axes.html)

Oscar

Create a custom chart, two stacked bars/month w/ two axes?
 
I would like to compare two data sets on the same chart using stacked bars.
The data ranges are different by several orders of magnitude in one case, so
I would like to use two axes. My x-axis is time in months. I would like to
have both data sets displayed against each month. I cannot find a
appropriate chart in PowerPoint's custom chart nor can I find instructions on
how to create a custom chart. Anyone have an idea? Maybe Excel is the way
to go.

John Mansfield

Oscar,

Perhaps these examples can help:

http://www.peltiertech.com/Excel/Cha...OnTwoAxes.html

http://www.pdbook.com/index.php/exce...with_two_axes/

----
Regards,
John Mansfield
http://www.pdbook.com

"Oscar" wrote:

I would like to compare two data sets on the same chart using stacked bars.
The data ranges are different by several orders of magnitude in one case, so
I would like to use two axes. My x-axis is time in months. I would like to
have both data sets displayed against each month. I cannot find a
appropriate chart in PowerPoint's custom chart nor can I find instructions on
how to create a custom chart. Anyone have an idea? Maybe Excel is the way
to go.



All times are GMT +1. The time now is 04:19 PM.

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