ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line & Double Stacked Charts (https://www.excelbanter.com/charts-charting-excel/94468-line-double-stacked-charts.html)

K

Line & Double Stacked Charts
 
Good day. I am trying to get a Double stacked chart to show a line. I can get
the line by creating a secondary Axis however the line isnt where I want it.
It is at the top of the tallest bar. Is there any way to get the line down to
a value I want it at.

Basically I am trying to create a capacity chart with two products running
on one machine by month. I need the line to be at a value that is straight
accross being the maximum machine capacity.

Any help would be greatly appreciated.

Thanks

K

Line & Double Stacked Charts
 


"K" wrote:

Good day. I am trying to get a Double stacked chart to show a line. I can get
the line by creating a secondary Axis however the line isnt where I want it.
It is at the top of the tallest bar. Is there any way to get the line down to
a value I want it at.

Basically I am trying to create a capacity chart with two products running
on one machine by month. I need the line to be at a value that is straight
accross being the maximum machine capacity.

Any help would be greatly appreciated.
Okay got it.


Just had to change the Catergory X axis crosses at to my capacity level on
the scale by right clicking on format axis
Thanks



All times are GMT +1. The time now is 06:33 PM.

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