Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating an changing scale on x axis for outlying cases
Hi
When I plot all my cases on a scatterplot, i get 90% of my cases all bunched up, and 10% way out on the right of the x-axis because they are outliers. The solution is to have the x-axis display a changing scale like the following. But i don't know how to do this. Can anyone help please? 10 20 30 40 50 60 100 200 300 400 Thanks Steve |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating an changing scale on x axis for outlying cases
Would a log scale work for you. Double click the x-axis and on the Scale tab
specify logarithmic. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steve BBC UK" <Steve BBC wrote in message ... Hi When I plot all my cases on a scatterplot, i get 90% of my cases all bunched up, and 10% way out on the right of the x-axis because they are outliers. The solution is to have the x-axis display a changing scale like the following. But i don't know how to do this. Can anyone help please? 10 20 30 40 50 60 100 200 300 400 Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the x axis in a scatter plot | Charts and Charting in Excel | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel | |||
Change the value axis scale | Charts and Charting in Excel | |||
secondary axis scale | Charts and Charting in Excel |