Categories: Sheets :

Spreadsheet chart settings have changed?

Showing 1-9 of 9 messages
Spreadsheet chart settings have changed? Mister Chun 7/14/11 7:04 PM
I have a chart depicting the buy/sell exchange rate for a three banks over many days.
The chart's range covers Date on the X-axis, and Rate on the Y-axis, taking data as below:

US Sell
15/12/2010 16/12/2010
DBS Sell 1.31         1.3252
UOB Sell 1.316 1.325
OCBC Sell 1.3145 1.3265
US Buy
15/12/2010 16/12/2010
DBS Buy 1.294 1.3092
UOB Buy 1.299 1.308
OCBC Buy1.295 1.307

This used to work, giving me 3 lines for buy and 3 lines for sell values on the chart.
A few days ago I receive this error message on the chart.
Error message: Column 4 cannot be of type string, it is a data column.

I can no longer put the buy and sell on the same chart. It still works if I only use one of it, either buy or sell.
Any ideas how it can be made back to normal or do I have to use twice as many charts now?
Re: Spreadsheet chart settings have changed? portfola 7/15/11 10:54 AM
I just found this same error today. A chart I have been using for four years suddenly doesn't work and simply says "Column #4 cannot be of type string, it is a data column"
Re: Spreadsheet chart settings have changed? Julich 7/17/11 4:55 AM
I get the same error on a Google Visualization Chart since a few days now, while it was working for months now and nothing has changed!
Re: Spreadsheet chart settings have changed? DrewKime 7/24/11 8:42 PM
Same here, a chart I've been using for several months just started getting this same error.

Well, to be precise I just *noticed* I'm getting the error. Now I'm thinking it may have been broken for over a week. Nice.
Re: Spreadsheet chart settings have changed? MisterChun 7/24/11 8:49 PM
Well obvious some changes have happened in the back end without our notice. Don't know if Google will come to our rescue any time soon, so the only solution now is either making multiple simple charts or directly read the values from the spreadsheet..
Re: Spreadsheet chart settings have changed? bob54321 7/26/11 10:33 AM
Several of my documents had the same error.  I just found that if you enter a 0 (zero) in any field that does not have data, it will clear the error.  Hope this helps.
Re: Spreadsheet chart settings have changed? portfola 7/26/11 10:57 AM
I think the problem is that it will not accept blank fields anymore. Something has to be there. Good luck all. I fixed mine.
Re: Spreadsheet chart settings have changed? MisterChun 7/26/11 7:11 PM
That kinda solved the problem! However entering 0 will cause the entire graph to resize to include zero as well, so I'll probably rearrange the entire table to minimize that.
Thank you so much bob and portfola!
Re: Spreadsheet chart settings have changed? DrewKime 7/27/11 8:03 AM
I tried it. Not only did it resize the chart, as MisterChun said, it still didn't cause it to appear where embedded. Sticking with the image version for now.