ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Stacked Bar - 2 Axes (https://www.excelbanter.com/charts-charting-excel/190323-stacked-bar-2-axes.html)

nerokyc

Stacked Bar - 2 Axes
 
How can I have a stacked bar using one axes combined with a line graph as a
second axis?

ShaneDevenshire

Stacked Bar - 2 Axes
 
Hi,

Plot all of your series as a stacked bar chart. Then select the one series
you want as a line chart and choose Chart, Chart Type and pick Line. To run
it along the second Y axis, select the line and choose Format, Selected Data
Series, Axis, Secondary Axis.
--
Cheers,
Shane Devenshire


"nerokyc" wrote:

How can I have a stacked bar using one axes combined with a line graph as a
second axis?



All times are GMT +1. The time now is 06:39 AM.

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