View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Opal Opal is offline
external usenet poster
 
Posts: 59
Default Coordinate secondary y axis to primary y axis

Is it possible to coordinate the secondary y axis on a chart
so that the maximum value is always 72 times the max value
on the primary y axis?

The primary y axis plots hours of work and the secondary
y axis plots $$. When the chart updates, we want to ensure
that the maximum on the secondary axis is equal to 72
times the maixum on the primary.

I have been searching but cannot find anything on this.

Thanks,