Primary % secondard vertical axis don't line up

A

Al Charbonneau

Hi

I am using Excel 2007 to do a chart that has a company's revenue presented
in columns on the primary vertical axis and the year over year change in
revenue presented in lines on the secondary vertical axis. The problem I
have is that in 1996, the company lost money and in 2008 it had a profit. I
would like to but seem unable to get the 1996 column to show below the line
while the 2008 column begins at 0. It appears as though the problem is
influenced by the secondary vertical column which needs to begin at 0.

Would appreciate help.

Thanks

Al
 
A

Al Charbonneau

Thanks for replying.

Your pdf illustrates exacly what I want but the explanation (zip file) of
how to get there is above my head. Is there a simpler explanation?

Thanks again.

Al
 
H

Herbert Seidenberg

One of many problems is that
when the company breaks even,
the % change for the next year approaches infinity.
A work-around adds complexity.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
How to apply the same Fixed Horizontal Scale to Both Vertical Axis 0
Assign data series to primary axis 1
primary/secondary axis next to each other 3
Custom Format numbers for learning chart 0
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 1
Combination chart - Column + Line with reverse category on Office 3

Top