Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the data in the attached XLS and i want to distribute the data based on. PPT attached. Can any one help me.I have pointed two rows in the PPT
Thanks in advance.
Challenge | Danger | Healthy | Trending |
yes ..you are right friend
Then it looks like Dave Lau had you pointed in the right direction. As he asked, you should also try to get the data file in a better format. Merged cells/rows are no fun.
For each chart dimension use Date(Date,'MMM-YYYY') to get the format you displayed a la "Mar-2017", et al.
Each chart should have 3 expressions:
Min(Healthy)
Avg(Healthy)
Max(Healthy)
Min(Challenge)
Avg(Challenge)
Max(Challenge)
Min(Danger)
Avg(Danger)
Max(Danger)
Min(Trending)
Avg(Trending)
Max(Trending)