Google Product Forums
Re: Why is one chart showing all dates, but not the other when chart types and data types are the same?
Jun 21, 2012 7:02 AM
Posted in group:
Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :
Thank you! I've made a copy of the spreadsheet, massively tidied it up using your formula from the other thread, and removed the automatically importing weather data.
Here's the sheet with all the graphs:
So, you can see the problem now: 2 of the graphs are showing all the dates, correctly, as expected. The other is only showing a few dates, with the time of 00:00:00.
I've re-imported all the data, re-made all the graphs.
In ALL cases, the date and time is dd/mm/yyyy hh:mm:ss
The other thing that is annoying the hell out of me is the way it formats numbers with a comma.
If I format the numbers as text, it looks fine, but then won't let me make a chart.
And yet, on one of the sheets, it seems that numbers are comma-free, but still behave like numbers.