Hello-
In the attached document, I have 4 charts on the first sheet that take their information from the last sheet.
Ideally, I'd like for the horizontal axis on these 4 charts to always display from the beginning of the current range to the current date. Otherwise, it could display from from the beginning of the current range to whatever is the latest column to have an entry other than "0"
Thanks in advance!
Last edited by ckirkwalsh; 09-13-2011 at 03:08 PM.
I don't think you need named ranges. Just use the NA() function. When Excel encounters NA's on the row or column of a table that is tied to a graph's axis it ignores them.
Changing the dates in the spreadsheet to a formula should work. For example, in cell B2:
=IF(DATEVALUE("8/12/11")+(COLUMN()-COLUMN($B:$B))*7<TODAY(),DATEVALUE("8/12/11")+(COLUMN()-COLUMN($B:$B))*7,NA())
Then drag that across the other cells in row 2.
Pauley
Thanks Pauley!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks