Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2018, 08:47 AM
DBenz DBenz is offline X axis graph all dates when date column contains specific dates..possible ? Windows 7 64bit X axis graph all dates when date column contains specific dates..possible ? Office 2010 32bit
Advanced Beginner
X axis graph all dates when date column contains specific dates..possible ?
 
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
  #2  
Old 03-27-2018, 09:48 PM
xor xor is offline X axis graph all dates when date column contains specific dates..possible ? Windows 10 X axis graph all dates when date column contains specific dates..possible ? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe you should consider answering responses to questions you posted earlier (such as: auto progress number evenly between two values across empty cells).

Of course it is possible that you can't use the proposed solution but if so, what about telling why to whoever tried to help you?
Reply With Quote
  #3  
Old 03-28-2018, 04:59 AM
DBenz DBenz is offline X axis graph all dates when date column contains specific dates..possible ? Windows 7 64bit X axis graph all dates when date column contains specific dates..possible ? Office 2010 32bit
Advanced Beginner
X axis graph all dates when date column contains specific dates..possible ?
 
Join Date: Dec 2014
Posts: 66
DBenz is on a distinguished road
Default

Hi, I looked in on Excel and replies, didnt see any on those I looked at, but overlooked the time progression one by mistake. I see one still has none, and looking again now there is one that happened last night whilst we in the UK are in bed, and hadnt after that, got round to all of them again due to being pulled away, so sorry I didnt get to answer yours in my normal timeframe, probably not the only one to not revisit a post within 4 days though.
I do normally look at posts then post new, in that order, but sometimes I post first whilst problem fresh in my mind as replying to posts can lose train of thought.

Quote:
Of course it is possible that you can't use the proposed solution but if so, what about telling why to whoever tried to help you?
Sorry you've lost me there, my two ideas here are not possible you say, I am to tell why that is to the person who tried to help me with them here, but I havent see anyone with help in this thread on this yet ?
Not sure how one tells someone why their own ideas are not possible anyway.

DBenz
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
X axis graph all dates when date column contains specific dates..possible ? Timeline - loop through all dates between first and last given and add date to column if not found carlos_cs Excel Programming 1 05-03-2016 09:25 AM
Autofill dates - how can I get the same date and consecutive dates? Exhale Excel 3 04-05-2016 03:11 AM
Proportionally spread dates on chart x-axis? jhoby Excel 0 06-07-2015 01:04 PM
Is this possible? - Calculate and Display the date range between 2 specific dates Premier-UK Excel 2 08-18-2014 05:43 AM
X axis graph all dates when date column contains specific dates..possible ? column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft