Changing the look of a graph

C

ChuckW

Hi,

I am graphing our top ten customers and their % change in sales by quarter
for the past four quarters. Two of our customer had an instance where their
change in sales of over 500%. Almost all other values for change in sales
was between -20% and +30%. The default Excel line graph has the major grid
lines and 100% increments with the to outliers near the top and all other
lines between 0 and 100%. It isn't very readable. I wanted to focus the
graph on the -30% to +30% range. Is there a way to do this?

Thanks,
 
S

Steven

If I'm understanding you, then it's an easy fix.

Double click on the axis, and a Format Axis box opens. Click on the Scale
tab, and force the scale.
 

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

Scale of Graph Axis 2
How to distribute/spread/map cost of project across different year 3
update graphs automatically either from same book or a new spreads 1
Changing a data series in a graph from a line to a bar 1
X-Y Graph with Months, Not Date on Axis 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
newbie pivot table question (using match to find a value) 1
Changing the scale major unit in a graph 2

Top