Feb 25, 2020
Graph isn't populating in Google Sheets - what am I doing wrong?
In column A3:A14, I have the months Jan - Dec listed.
In row B2:E2 I have the years/providers.
In cells B3:E14 I have my figures (monthly bills) recorded. There are some cells within this that are blank.
When I select A3:E14, the chart comes up blank - displays a 'No data' message.
I want my X axis to be the months Jan - Dec.
I want my Y axis to be the price range (say $30 - $100).
I also can't make sense of the "Add Series" feature as whatever I put in it doesn't like.
Can someone please help me work this out?
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Last edited Feb 25, 2020
Mar 6, 2020
Original Poster Keszia marked this as an answer
Mar 3, 2020
if you go do File>Spreadsheet Settings, you should be able to adjust the Locale. I suppose Australia would be the best option for you?
I wonder how that sheet you shared got set to the UK?
Matt
Original Poster Keszia marked this as an answer
All Replies (8)
Mar 1, 2020
Mar 1, 2020
Hey there,
I think it's possible to solve this problem for you, but I and others here would greatly benefit from being able to see a sample of the problem. Please check out this pinned post for the best way to do it.
Tip: Read the Tips post above, then check your sharing settings before posting - you want "Anyone with the link can Edit"
Cheers,
Matt
Matt
Mar 3, 2020
Hi Keszia,
Because your sheet locale is set to UK, but you were pasting your prices in from somewhere that had the US $, the numbers were being read as text instead of numbers so the graph wouldn't work. I used this simple formula in cell B3 on the MK.Help tab, and dragged it around to populate actual number values in GBP.
=1*MID(Sheet1!B3,2,10)
You can see the resulting graph on that sheet as well. hope this helps!
Matt
Mar 3, 2020
if you go do File>Spreadsheet Settings, you should be able to adjust the Locale. I suppose Australia would be the best option for you?
I wonder how that sheet you shared got set to the UK?
Matt
Original Poster Keszia marked this as an answer
Mar 6, 2020
So I've changed the locale to Australia (closest option I suppose that uses $), how can I apply the same sum/rule you did to have the chart populate like you did with GBP?
Original Poster Keszia marked this as an answer