| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Many low values, one high value- how do I avoid skewed chart?
I am trying to show a range of values (y-axis) in which on value is much
larger than the rest. I would like to know if anyone can suggest a way to alter the y-axis so that my low values are not grossly skewed by the one high value. Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Many low values, one high value- how do I avoid skewed chart?
1. Use a logarithmic scale
2. Make a broken axis: http://peltiertech.com/Excel/Charts/BrokenYAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "bpmedtech" wrote in message ... I am trying to show a range of values (y-axis) in which on value is much larger than the rest. I would like to know if anyone can suggest a way to alter the y-axis so that my low values are not grossly skewed by the one high value. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart problem: values in column A doen't show on x-axis | Excel Discussion (Misc queries) | |||
| add to values in the chart not on the worksheet | Excel Discussion (Misc queries) | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Can it be done | Excel Worksheet Functions | |||
Linear Mode
