Derek.Laur
New Member
Hi everyone,
I am trainer that has recently moved into analytics and I am trying to create KPI report. I have been reading through the http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/ series and found it quite helpful.
However, I did stuck and I could please use a few pointers and help where I broke my sheet. Here is a link to the spreadsheet:
https://docs.google.com/file/d/0B5ivitjLxD8EWWlBRFpGQmtacVk/edit?usp=sharing
The conversion micro chart is not displaying and the scatter chart is displaying the data properly. I know there are some blank values here and there, but the conversion and scatter chart for the values that are there shouldn't be affected I wouldn't think.
Any insight is greatly appreciated.
Thanks,
Derek
I am trainer that has recently moved into analytics and I am trying to create KPI report. I have been reading through the http://chandoo.org/wp/2008/08/20/create-kpi-dashboards-excel-1/ series and found it quite helpful.
However, I did stuck and I could please use a few pointers and help where I broke my sheet. Here is a link to the spreadsheet:
https://docs.google.com/file/d/0B5ivitjLxD8EWWlBRFpGQmtacVk/edit?usp=sharing
The conversion micro chart is not displaying and the scatter chart is displaying the data properly. I know there are some blank values here and there, but the conversion and scatter chart for the values that are there shouldn't be affected I wouldn't think.
Any insight is greatly appreciated.
Thanks,
Derek