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

sideways stacked bar charts with line series on the same axis 0
Excel 2007 charts: want to avoid zero values 1
How to convert X-axis in a Gannt chart to numbers 11
Custom Waterfall - selective stacking, crosses X-axis, no end colu 3
2 Charts but same Y-axis (max-value) 2
Newbie needs a little help on the value axis 1
Grouping axis scale multiple charts 1
Can I set 2 charts to have the same Y axis? 0

Top