Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary % secondard vertical axis don't line up
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary % secondard vertical axis don't line up
Excel 2007 Chart
Align zero of primary and secondary axis. With macro. http://c0718892.cdn.cloudfiles.racks.../03_17_10.xlsm Pdf preview: http://www.mediafire.com/file/hm4elmyogmm/03_17_10.pdf |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary % secondard vertical axis don't line up
If you don't want to open a workbook, here's a web page with an answer:
Align X Axis to Y=0 on Two Y Axes (VBA) http://peltiertech.com/Excel/Charts/AlignXon2Ys.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/16/2010 8:38 PM, Al Charbonneau wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary % secondard vertical axis don't line up
Thanks - you are always very helpful.
Al "Jon Peltier" wrote: If you don't want to open a workbook, here's a web page with an answer: Align X Axis to Y=0 on Two Y Axes (VBA) http://peltiertech.com/Excel/Charts/AlignXon2Ys.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/16/2010 8:38 PM, Al Charbonneau wrote: 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 . |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary % secondard vertical axis don't line up
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 "Herbert Seidenberg" wrote: Excel 2007 Chart Align zero of primary and secondary axis. With macro. http://c0718892.cdn.cloudfiles.racks.../03_17_10.xlsm Pdf preview: http://www.mediafire.com/file/hm4elmyogmm/03_17_10.pdf . |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Primary % secondard vertical axis don't line up
One of many problems is that
when the company breaks even, the % change for the next year approaches infinity. A work-around adds complexity. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2nd Vertical Axis and line graph | Charts and Charting in Excel | |||
Problem adding a vertical line to a graph with months on x-axis | Charts and Charting in Excel | |||
Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
Add vertical lines to a line chart (already has 2 Y axis) | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel |