Dashboard prettiness in Excel
So, in my new role I'm supposed to update a dashboard that the previous incumbent created. Generally I consider myself fairly high-level on my Excel skills but I am truly stumped and the Google has been of limited help for the first time ever, so I hope one of you can fill in the blanks for me.
The old-me created a dashboard with a source table and then turned it into a pivot table with red/yellow/green indicator icons based on the number (3,2,1 respective) in the status column of the source table. I updated the source table to the projects for 2016, updated the dates to 2016 dates and removed the old status and put in the statues for Jan-2016 and then refreshed the pivot tables. The project names updated and the timeline updated but the indicator icons not only disappeared, I can't even figure out how to let it just be a "regular" sum pivot table until I figure out the icons.
I found exactly 1 article that points me to the right thing but I feel like I'm missing something when it says "Edit the widget's script". Where exactly would I find the widgets script on a pivot table?
(I can't provide the actual dashboard since it has confidential project names and budgets in it, sorry)