Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2nd Vertical Axis and line graph mareng Charts and Charting in Excel 1 April 15th 09 09:28 PM
Problem adding a vertical line to a graph with months on x-axis [email protected] Charts and Charting in Excel 2 May 22nd 07 01:33 PM
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 09:52 PM
Add vertical lines to a line chart (already has 2 Y axis) PaulW Charts and Charting in Excel 3 November 21st 06 05:19 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 09:45 PM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"