Hello guys,
I've looked around the internet and couldn't find an answer that would fit my need so I come with a question.
I'm in the process of trying to make a dynamic chart that updates every month. The way we have it set up is we have a Data Input tab where all the numbers go, and that will populate multiple other tabs within the sheet. For every column, there's a different month, and I'd like to have it populate only when there is a non $0 number (or at certain date like middle of the month) in an automated way. I'm going to be passing this on to some other people that really aren't Excel savy at all, so just changing some ranges on the graphs can be difficult for them.
Currently what I have right now is Chart 1 (on the Excel sheet: Charts), but that includes dates up to December 2015 with half of it being 0... I would love to have something like Chart 2, that dynamically adds months whenever something that's > 0 is entered.
Anyone have any idea?
Thank you!
Bookmarks