Panter
Just call me Chris...
- Location
- Sittingbourne, Kent
Very simple one I'm sure but I'm absolutely hopeless at these.
I've got a spreadsheet set up where I can log my weight every week. It's very basic, I enter stones and pounds in two columns, it then converts to pounds in a third.
I've got a basic line chart set up in the spreadsheet which plots the data taken from the "lbs" column which works just fine.
The formula to convert to lbs is copied down the spreadsheet so that for every entry not yet filled in it's displaying a "0"
Problem is, it's showing those 0 values on the chart so it works fine for all the data entries, then drops sharply down to bottom out on the baseline. This really affects the scaling so it doesn't look right.
What can I do so that it only plots a positive value when it's entered?
BTW, this is in Google docs but it seems to pretty much mirror what Excel does so I'm sure Excel commands would work (or I can find the equivalents)
I've got a spreadsheet set up where I can log my weight every week. It's very basic, I enter stones and pounds in two columns, it then converts to pounds in a third.
I've got a basic line chart set up in the spreadsheet which plots the data taken from the "lbs" column which works just fine.
The formula to convert to lbs is copied down the spreadsheet so that for every entry not yet filled in it's displaying a "0"
Problem is, it's showing those 0 values on the chart so it works fine for all the data entries, then drops sharply down to bottom out on the baseline. This really affects the scaling so it doesn't look right.
What can I do so that it only plots a positive value when it's entered?
BTW, this is in Google docs but it seems to pretty much mirror what Excel does so I'm sure Excel commands would work (or I can find the equivalents)
