Formatting a data series to run value axis to value axis

[Eva Whitley]

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]

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]

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