Excel Customer Service
April 18, 2015
I have a dashboard that has some graphs showing data monthly and others showing quarterly. They are all using the same "raw data" sheet. For the quarterly, I want to avoid showing Q2, for example, until all 3 months of Q2 are there. Each chart has their own "period" named range.
I tried to control with a field that indicated if month is July, then offset is x and use that value for the offset formula of data i.e.
but I couldn't get that to work. Any suggestions welcome, thanks.
Most Users Ever Online: 57
Currently Online: ELINOR IGNACIO, KingTamo
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas