Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Same Value Axis Numbers in Four Charts
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Same Value Axis Numbers in Four Charts
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/...nkToSheet.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "CJ" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X AXIS ON CHARTS | Charts and Charting in Excel | |||
y-axis versus x-axis charts | Charts and Charting in Excel | |||
Charts on 2 axis' | Charts and Charting in Excel | |||
charts....x and y axis | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |