View Single Post
 
Old 03-27-2018, 08:47 AM
DBenz DBenz is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Dec 2014
Posts: 66
DBenz is on a distinguished road
Default 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
Reply With Quote