Line & Double Stacked Charts

[K]

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]

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