Got a pie chart--any chart would work actually.
I have a 2-column table that produced the chart.
Once a row in that table is entered (and the pie chart updated..it's dynamic) I wanted to conditionally format the cell to represent the color given in the pie chart.
The only way I can think of this is to:
1. make a bunch (and I mean a bunch since my table supports 194 entries though I'd never get that far) of entries.
2. Record the fill values of each wedge of the pie (they seem to come at a certain order the same way each time)
3. Make a conditional for the rows of the table that give it fill when occupied.
It's tedius but I don't see a way around it.
Thoughts?
Bookmarks