create chart line

J

joexeve

I have data form 90 % still 100 %

I want to to show the data in a chart

but the chart must show from 0 still 100 % but from 90 still 100 %
must show for adding one
ex: 0 10 20 30 40 50 60 70 80 90 91 92 93 94 95 96 97 98 99 100 in the
vertical line

please, somebody help me???

jubliandi.blogspot.com
 
D

Dave Curtis

Hi,

You could add a dummy series to add the tick marks for 91 to 99, though if
you label them with the numbers, they will look very squashed unless your
chart is very tall.
You could try to rescale your data and use a broken axis.
A log scale could work, but would distort your data.

See Jon Peltier's and Andy Pope's pages for ideas.

Having your axis scale going from 0 to 100 is not ideal for showing the
variation in numbers fro 90 to 100.

Dave
 
B

Bernard Liengme

Right click the axis; open the Format Axis dialog and set the scale Min = 0;
Max = 1
best wishes
 

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

Scatter Chart 1
Make a mekko chart in Excel 2007 in three easy Steps 1
Gap Chart 3
VLOOKUP 2
Chart with differing x axis 1
Combine 2 Charts 2007 Excel 1
Creating visible Pass / Fail areas 1
Cumulative chart 1

Top