Vertical axis shows 0s when more or less than 2 decimal numbers are present in scatter.

As the title shows, that is the problem I've been having with Excel and I can't figure out what the problem is and it's driving me mad.

I am trying to make a scatterplot with values on the Y-axis having three decimal numbers, but whenever I change the decimal numbers to anything that isn't 2 it changes everything to a bunch of zeroes. (See attached image).

The values in "Average" are all numbers.
The values haven't been copy/pasted so it probably doesn't think it's text.

Screenshot 2018-10-13 at 11.58.58.png

Welcome to the forum!

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

The number columns are set as general - however, they respond correctly if the cell format is changed to number.

I do not understand or see what this issue is:

Whenever I change the decimal numbers to anything that isn't 2 it changes everything to a bunch of zeroes.

Where is this "bunch of zeroes"?

I'm really sorry, but I do not see that here. The number of decimal places increase in the veritcal axis labels, but the values do not change to zero.

I am running Excel 365, but with a UK locale.

OK, well hopefully someone with the non-subscription version will chip in. Please update your profile to correctly reflect the version you are using. Thanks.

If it helps, when I open your sample file, everything looks normal. Naturally, my copy of Excel uses "." for the decimal separator, so that's what I see.

Related to that, one thing I notice in your screenshot is the inconsistent use of "," as the decimal separator. I notice that your spreadsheet cells are all using "," as the decimal separator. However, 3 of the 4 axes (the 3 axes that look correct) appear to all use "." as the decimal separator. The axis that is having the problem appears to be trying to use "," as the decimal separator. I have never seen Excel use a mix of decimal separators (one part of a spreadsheet uses "." and "," as decimal and thousands separators, while another part of the same spreadsheet uses "," and "." instead), but that almost looks like what is happening. And that could make sense. If the three correct axes are formatted to show tenths, and the non-working axis is somehow formatted to show thousands (where the largest value is less than one-half), then the display would be just like your screenshot.

I would suggest you look real carefully at what Excel is trying to use for decimal and thousand separator and make sure that it is doing this correctly. As one who never really works with anything other than the US standard of "." and "," for decimal and thousand separator, I cannot comment on exactly what to look for to correct this kind of thing, but that's where I would be looking at this point.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.