X axis graph all dates when date column contains specific dates..possible ?
Hi,
Column A has dates 365 per year. B has meter readings (sporadic), C has days between readings, D has gas used between readings, E has gas per day.
So as to make the calculation of C and D and E easy, with formula referring to the cell above, so copy paste repeatable down the entire column, I opted to filter rows in B with 0 in it then delete those rows.
Col A will be the X axis in a graph BUT I want the X axis to feature 365 days, with the rows populating the appropriate date on that axis, with gas used per day for the Y axis is this possible ?
Otherwise can I somehow filter out the rows with 0 in for B, so that I can do that formula act as planned, referring to the row above that does have a figure to work on, something like filter find row with 0 in B column, then hide row and exclude row from being seen by formula ?
DBenz
|