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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping axis scale multiple charts 1
2 Charts but same Y-axis (max-value) 2
Newbie needs a little help on the value axis 1
excel2007 pivot table chart x-axis 1
Custom Waterfall - selective stacking, crosses X-axis, no end colu 3
How to convert X-axis in a Gannt chart to numbers 8
x-axis scale changes 3
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0

Top