Same Value Axis Numbers in Four Charts

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
 
A

Andy Pope

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
 
Top