Forum

Notifications
Clear all

Combo Box/Pie Chart Q - Different Chart Types?

3 Posts
2 Users
0 Reactions
96 Views
(@adegrandchamp)
Posts: 6
Active Member
Topic starter
 

Encountered something weird when building my first interactive dashboard (thanks for the awesome course, Mynda!)

I have a combo box set up to toggle a pie chart between two different data sets. 

When I toggle it to one option, the pie chart looks great. It's accurate, it's lovely, it makes sense.

When I toggle to the second option, the pie chart disappears.

So then I tried a donut option, just to see what happens. Now I have one toggle as a pie chart and one toggle as a donut chart. At some point I got two different donuts, one with an "explosion" at the center that I couldn't undo. But we seem to be back to the pie/donut, inexplicably. Nothing has changed about the data set.

This is clearly not the end of the world, but it is bothering me. Why can't I get the pie on both? 

If it helps, I need to do this on a Mac (I know!) and data from two pivots (I know! I know!) so I set up a workaround; the data set is a simple sheet using the IF and GETPIVOTDATA functions to populate. 

 
Posted : 02/02/2017 5:37 pm
(@adegrandchamp)
Posts: 6
Active Member
Topic starter
 

Whoops! Figured it out. Silly and simple mistake.

 
Posted : 02/02/2017 6:27 pm
(@fravis)
Posts: 337
Reputable Member
 

Can you share your solution (or mistake) with us, so new viewers can also learn from this? Thanks!

 
Posted : 03/02/2017 4:22 am
Share: