create chart line

  • Thread starter Thread starter joexeve
  • Start date Start date
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
 
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
 
Right click the axis; open the Format Axis dialog and set the scale Min = 0;
Max = 1
best wishes
 
Back
Top