Hi all
I have a graph which tracks the following cells, these sit below date in row 2 and the corresponding columns.
Data to be graphed in AY3 below date in AY2 (This the data the builds the graph)Please Login or Register to view this content.
Data to be graphed in AZ3 below date in AZ2
Data to be graphed in BA3 below date in BA2 and so on.
What I’d like to do is have the graph show the last 30 days of data (from today backwards). A rolling graph with the 30 days of current data.
How would I code this?
Thanks. Dave
Moderator's note: Corrected error in code tags. 4lowie, the closing tag is supposed to be /CODE not CODE/.
Bookmarks