Y Axis is repeating values - can't figure out why

F

fuzzyfreak

Using Excel XP.

I have a simple X & Y line graph which plots some numbers (y axis) with
some months (x axis)

At present I have January to December and only Jan and Feb have values
next to them (both 0.4) - the rest have a #DIV/0! because the figures
have not been entered - not that this should cause a problem, it never
has before.

On the Y axis, the values start at 0 and go up as follows -

0.1, 0.1, 0.2, 0.2, 0.3, 0.3, 0.4, 0.4, 0.5

This can't be right, surely - it is all set to auto so why are some
values repeating, all my other graphs are fine.
 
R

robert111

format the numbers to 2 decimal places to establish if it is a rounding
problem
 

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

Excel Charting Problem 2
Scaling time on the x-axis of a graph 1
Defining scale on y axis 1
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) 1
how can i plot two different y-axis graph with same x-axis 1
X-Axis Frustration 2
Stacked chart 1
How do I change scope of Y axis scale in MS excel graphs 1

Top