Categories: Sheets : Ask a "how-to" question :

Why is one chart showing all dates, but not the other when chart types and data types are the same?

Showing 1-6 of 6 messages
Why is one chart showing all dates, but not the other when chart types and data types are the same? lardconcepts 6/20/12 4:20 AM
See this chart? https://docs.google.com/spreadsheet/ccc?key=0AmkhuHmI5mk1dHpMNE13WWxobGo0dWFtMWMxSnFSRWc&pli=1#gid=5
Every single point has a date - perfect, just what I want.

But this chart is not so good: https://docs.google.com/spreadsheet/ccc?key=0AmkhuHmI5mk1dHpMNE13WWxobGo0dWFtMWMxSnFSRWc&pli=1#gid=10
Yes, I know I've maximized one, but I've tried everything - I've tried recreating from scratch, I've tried plotting null points, I've tried different layouts, different angles for the dates etc.

What I don't understand is why the first chart is showing all the points, but the second is not, when the input data for both is 3 columns: date and time, download speed, upload speed.

Any ideas? Have I missed something obvious?

Also, it seems that when you move a chart to its own sheet, it is then "stuck" at the size of the monitor of the person who made the chart at that time, and doesn't re-scale to fit smaller monitors. Is this correct?
Re: Why is one chart showing all dates, but not the other when chart types and data types are the same? MarinusP 6/21/12 4:12 AM
Hi

I can get access to the "normal" sheets, but not to the charts which have their own sheet.

It might be an idea to:
  • Make a copy of the spreadsheet
  • Remove the ow-sheet-charts
  • Recreate the charts on a normal sheet.
Re: Why is one chart showing all dates, but not the other when chart types and data types are the same? lardconcepts 6/21/12 4:27 AM
What sort of error are you getting when trying to view the charts? I couldn't even load it at all at first! Had to sign out and in again.
I was getting "Oops. Error writing records. (undefined: Internal abort)". As well as all the other error messages (see attachments).

This spreadsheet is giving me so much grief - sometimes it completely locks up and I need to reload, sometimes I load it to find everything greyed out and I need to click "sign in" on the top right (even though I was already signed in and clicking "sign in" immediately refreshes it to be writable etc.

Is it my imagination, or does Spreadsheets actually seem to be getting flakier as time goes on?
Or is it just that, as I'm doing more, I'm finding more bugs?
Re: Why is one chart showing all dates, but not the other when chart types and data types are the same? MarinusP 6/21/12 4:33 AM
Hi

Yes I also got such error messages, quickly flashing after each other, trying to reload over and over.

When I open the spreadsheet using a different #gid (sheetnumber) of a normal sheet, it works fine, however, if I click on a tab of a chart, nothing happens....
Re: Why is one chart showing all dates, but not the other when chart types and data types are the same? lardconcepts 6/21/12 7:02 AM
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: https://docs.google.com/spreadsheet/ccc?key=0AmkhuHmI5mk1dG5UYmRQQkUtOFVsNTBUNTJlalBRUFE&rm=full#gid=8

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.
Me confused!
Re: Why is one chart showing all dates, but not the other when chart types and data types are the same? MarinusP 6/21/12 1:38 PM
Hi

I've taken a look at your charts, and I think the one you say is not correct, is correct, and the ones you say are correct, are not correct.

Let me try to explain. If you have a chart which goes, on the X axis, from 0 to 10, then you want below the X axis, be shown:
  • 0,1,2,3,4, etc...
  • but not: 0.76 , 1.47 , 1.61 , 3.89 , etc..
with other words, you want to have the numbers on the X axis linear, right. Well, that will happen, if the dates in the first column are really dates (dates = numbers, formatted as a date) which is the situation with the top-left chart.

In the other 2 charts, the dates, are no real dates, but somewhere on the way, they have become text.

I've seen you used the function: TO_DATE. I have never used that, but it seems not to have the expected result. I made a copy of your spreadsheet, and set on sheet BT Data... all date column to "123" > Date, and then the chart showed the dates, but not all different times of a day.