Formatting a data series to run value axis to value axis

I am working on a combination chart where two data series are stacked
and the third data series is shown as a line chart. What we want is
for the data series line is to go from the value axis to the secondary
value axis, rather than starting from the first value in the data
series to the middle of the last value in the data series. Gap width
is grayed out. Is there some way of doing this? I can mail a sample to
anyone who wants to see an example of what I'm talking about.

I did a quick look in Google Groups but I didn't see anything that
looked like it applied. I appreciate any help you can give me. --Eva
Whitley

Eva -

Take a look at this web page:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Eva Whitley wrote:

> I am working on a combination chart where two data series are stacked
> and the third data series is shown as a line chart. What we want is
> for the data series line is to go from the value axis to the secondary
> value axis, rather than starting from the first value in the data
> series to the middle of the last value in the data series. Gap width
> is grayed out. Is there some way of doing this? I can mail a sample to
> anyone who wants to see an example of what I'm talking about.
>
> I did a quick look in Google Groups but I didn't see anything that
> looked like it applied. I appreciate any help you can give me. --Eva
> Whitley

Jon Peltier <DOjonNOT@SPAMpeltiertechME.com> wrote in message news:<egGUxYYLEHA.1340@TK2MSFTNGP12.phx.gbl>...
> Eva -
>
> Take a look at this web page:
>
> http://peltiertech.com/Excel/Charts/AddLine.html
>

Thank you Jon. I've bookmarked this link and will use this method to
fix my charts. --Eva Whitley