Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Is it possible for a single chart to have multiple Y axes scales

Is it possible to have separate Y-axes scales for each series in an XY graph
and to have a separate Y-axis "line" with tick marks for each series? All
series have a common X-axis.

Y1 Y2 Y3 Y4
| | | | __________
X

I don't want to multiply or divide each series by an arbitrary value so they
can plot against a common Y scale.

Chuck
--
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Is it possible for a single chart to have multiple Y axes scales

only 2 - primary and secondary Ys are available in any one chart
you 'could' layer charts over top of each other - messy and potentially
flammable, but it will work

make all charts the same size
format so only 1 set of X axis values are visible, format the x axis lines
so they are visible
use x axis lines to align all charts with each other

- vdJ

"Chuck" wrote in message
...
Is it possible to have separate Y-axes scales for each series in an XY
graph
and to have a separate Y-axis "line" with tick marks for each series? All
series have a common X-axis.

Y1 Y2 Y3 Y4
| | | | __________
X

I don't want to multiply or divide each series by an arbitrary value so
they
can plot against a common Y scale.

Chuck
--



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Is it possible for a single chart to have multiple Y axes scales

On Thu, 5 Jan 2006 22:04:34 -0500, "voodooJoe" wrote:

vdj, Thank you very much for your help.
Layering looks promising. Will try it later today. Graph format from one set
of data to another is fairly consistant. Maybe not too much friction between
layers.

Chuck
--

only 2 - primary and secondary Ys are available in any one chart
you 'could' layer charts over top of each other - messy and potentially
flammable, but it will work

make all charts the same size
format so only 1 set of X axis values are visible, format the x axis lines
so they are visible
use x axis lines to align all charts with each other

- vdJ

"Chuck" wrote in message
.. .
Is it possible to have separate Y-axes scales for each series in an XY
graph
and to have a separate Y-axis "line" with tick marks for each series? All
series have a common X-axis.

Y1 Y2 Y3 Y4
| | | | __________
X

I don't want to multiply or divide each series by an arbitrary value so
they
can plot against a common Y scale.

Chuck
--



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Is it possible for a single chart to have multiple Y axes scales

On Thu, 5 Jan 2006 22:04:34 -0500, "voodooJoe" wrote:

only 2 - primary and secondary Ys are available in any one chart
you 'could' layer charts over top of each other - messy and potentially
flammable, but it will work

make all charts the same size
format so only 1 set of X axis values are visible, format the x axis lines
so they are visible
use x axis lines to align all charts with each other

- vdJ

Thank you. It was a bear to setup, but it works.

Chuck
--
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
Radar charts with unequal scales along the axes Stan R. Charts and Charting in Excel 2 October 17th 07 07:03 PM
Lining up scales on primary and secondary y axes MarkN Charts and Charting in Excel 2 January 9th 06 12:26 AM
xy chart -- x and y axes scales min and max Brad Charts and Charting in Excel 1 December 5th 05 10:19 PM
Radar Chart with Multiple scales Amanda Charts and Charting in Excel 5 June 16th 05 11:32 PM
Can I insert multiple scales on the Y axis of a single XY graph? Saba Demian Charts and Charting in Excel 3 April 10th 05 10:43 PM


All times are GMT +1. The time now is 12:03 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"