Hi, I am building a workbook with multiple worksheets.
Each worksheet will have the same "template" for data, as in the example attached.
There is a table in the template showing monthly returns over a 4 year period. Each year has its own row.
While every worksheet has the same template, there will be a number of empty cells. These cells won't be filled because there is no data for that particular month.
Is there a way to generate a graph which will dynamically change its beginning and ending periods depending on whether or not cells have data?
Note that a "0" means a zero return. An empty cell means no activity.
Can anyone help me with the formula?
Thanks!
Bookmarks