Hi all, I'm using a formula to auto fill the x axis of a "line chart w/ markers" given a start date and end date, =IF('Formula Sheet'!$A$1+7*(COLUMNS($A:A)-1)<='Formula Sheet'!$D$1,'Formula Sheet'!$A$1+7*(COLUMNS($A:A)-1),"")
My question is, in the chart input sheet where these dates go, I have to manually "hide" the columns that have no values (dates) so my line chart x axis only shows the dates and not empty markers for the empty cells. My dates change, and are in increments of 7 days, so if my start date for one project is 5/25/13, and end date is 6/25/13, the formula would create 5 weeks/columns of data, but my chart input sheet has room for up to a year of possible weekly dates in case a different project is a longer, or shorter length.
I attached some pictures to help explain. Is there a function I can utilize so excel does this automatically?
Thanks for the help!
Bookmarks