Same Value Axis Numbers in Four Charts

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I'm tracking sixteen separate things, four to a chart ... I have all four
charts together on one worksheet ...

The values of the tests I'm running range anywhere from 14.50 to 15.50 ...

The first chart shows the Value Axis Numbers from 14.30 to 15.40 in
increments of .10 ... The second chart shows the Value Axis Numbers from
14.80 to 15.20 in increments of .05 ...

How can I make all four charts look the same ...???

Thank you ... CJ
 
Hi,

The simplest way is to add a dummy series to all four charts. This series
needs to contain the minimum and maximum values to be found across all data
sets.
You then format the dummy series so it has no fill/marker/border.

Otherwise a VBA approach is required to set the scale parameters to values
stored in cells.
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Cheers
Andy
 
Back
Top