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" 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