can you create a break in the chart scale

D

duncanw

Is possible to change the scale of the chart to reflect a large range of
data ie creat a break in the scale?

I have a data set that consists of variables ranging from 25 to 0.1,
there are roughly three variables that are in between 20 - 25 and the
remainder are (25) are in the range of 0.1 to 1. As such, when I graph
this data in a regular bar chart I can only see the three variables that
are between 20 - 25 as the scale does not allow me to the lower valued
variables. In regards to this problem I would like to break the scale
so it would ready, 0.2, 0.2,0.3 ....1, 5, 10, 15, 20, 25.

If you can help with this problem it would be much appreciated.
 

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

Possible? Variable X and Y data sources and Auto Charting 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
How to make a break in chart scale? 1
Small Multiples with Common Scale 2
Adding Additional Points to a Line Chart 7
scaling of columns: same maximum height despite different ranges 2
Constant % on X axis 2
Excel Chart Scaling 1

Top