Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Graph with two scales - calling a graph expert !

Hi all,

I have the following graph:
- left vertical axis, showing absolute values
- bottom horizontal axis, showing months
- right vertical axis, showing percentages

The problem lies in scale of the right vertical axis. The
zero value ( o %) does not cross the horizontal axis at
the correct spot, even after indicating that it should
cross at zero (in the "Format axis" option).

In other words, in the scale of the left axis the
horizontal line crosses at zero, however in the scale of
the right axis it doesn't !

To correct this I need to go into each graph and adjust
the mininum, maximum, major & minor unit to such an extent
that the zero in scale hits the horizontal axis at the
right spot. Needless to say, this is a nightmare ...

Any help would be greatly appreciated.

Regards
Steve P


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Graph with two scales - calling a graph expert !

a good start is to look in Jon Peltier's site:
http://www.geocities.com/jonpeltier/...rts/index.html
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
equations on appropriate graph scales Jon Excel Discussion (Misc queries) 0 November 15th 08 08:43 AM
How do I add two vertical scales to a line graph? IronRobbie Charts and Charting in Excel 1 June 12th 07 02:46 AM
bar graph with varying Y scales [email protected] Charts and Charting in Excel 3 September 14th 06 11:14 PM
how can i graph with log-log scales? AirdromeTom Charts and Charting in Excel 1 December 15th 04 05:06 PM
how can i graph with log-log scales? AirdromeTom Charts and Charting in Excel 1 December 15th 04 04:34 PM


All times are GMT +1. The time now is 12:10 AM.

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"