Making a graph with null data or text in Google Spreadsheet
November 3, 2010 8:14 PM Subscribe
Google Documents changed the way it handles chart data and now I can't make a simple graph.
posted by Gandhi Knoxville to Computers & Internet (6 answers total)
I track my lifting with Google Docs. Part of it is determining my lift:mass ratio. But I don't do every lift every day, so I would use a formula like =IF(G2=0, "N/A", G2/B2) to make sure that I didn't have graphs that dropped to zero every alternate day.
Previously, the chart function handled this fine. Wherever it saw the text "N/A", it wouldn't put a dot on the chart and the line graph was just fine. Now, with Google's cool new awesome amazingly new super-simple smart charts, it flips out over something this basic and tells me "The required data format for the line chart doesn't match the current data.
The first column should be a string, and contain the category label. Any number of columns can follow, all must be numeric. Each column is displayed as a separate line"
So what's the solution? I don't want to put in fake data, and I don't see any way to go back to the old charts that, you know, worked logically.