Hi all. I have run into a problem that I can't get through, but I'm sure someone here will manage it"
I want make a visual presentation of important data for each month. For example a pie chart of the sales split between Sweden and Denmark this month. (Months in the columns and Countries in the rows. Please see attached file.)
My problem is that the month is changing every month Now I have a pie chart of January but when it turns to February, i don't want to have to go into "mark data" and change cells. Rather, I would just like to have a cell that I change from "Jan" to "Feb" and the data selection changes.
How do I do this?
I hope I made myself clear. If not, please ask!
Bookmarks