| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I use a split scale on a value (Y) axis?
If the maximum of one data point is much greater than that of all the other
data points, is is possible to split the scale on the Y axis, so I can enlarge the lower data points and still show the max of the largest data? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Can I use a split scale on a value (Y) axis?
yes see Tushar Methta's page
"deswork" wrote in message ... If the maximum of one data point is much greater than that of all the other data points, is is possible to split the scale on the Y axis, so I can enlarge the lower data points and still show the max of the largest data? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Can I use a split scale on a value (Y) axis?
And just in case the OP is not familiar with Tushar's site here is the link.
http://tushar-mehta.com/excel/newsgr...ial/index.html and some alternatives. http://peltiertech.com/Excel/Charts/BrokenYAxis.html http://www.andypope.info/charts/brokencolumn.htm Cheers Andy R.VENKATARAMAN wrote: yes see Tushar Methta's page "deswork" wrote in message ... If the maximum of one data point is much greater than that of all the other data points, is is possible to split the scale on the Y axis, so I can enlarge the lower data points and still show the max of the largest data? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chaning X axis scale in Excel 2003 | Charts and Charting in Excel | |||
| Link a cell to min & max box for Value (X) axis scale? | Charts and Charting in Excel | |||
| "Scale breaks" required in (Z) axis | Charts and Charting in Excel | |||
| How do I split the y-axis scale on a chart? | Charts and Charting in Excel | |||
| secondary axis scale | Charts and Charting in Excel | |||
Linear Mode
