Placing an Axis Break on the Y axis

W

Wrangler

I am using Excel 2007 and I have data that I need to display on one
scatter plot. However, the initial value for one variable on the
graph dwarfs the rest of the data. I want to insert a break in the y-
axis for units. For example the y values from 5-20 are useless to my
data. So I want to remove those values from the y-axis. If I could
take them out it would show greater detail in the variation below 5.
I know this is possible in other programs, but I would prefer to do
all of my graphs in excel. Any help would be awesome. Thanks.
 

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

How do I put words as the Y axis values? 0
Make Y-axis values correspond to x- axis value 1
Customised Axis Values 2
Graphs: 2 Lines on secondary Y-axis? 1
how to make break the y axis for the in the line chart 3
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Changing y axis labels 1
How can I make a scatter plot graph with a category x-axis? 0

Top