Forum Discussion
Pie chart - data may not be formatted to work?
Yes, copy/pasting the chart and changing the visual level filter is probably the quickest way here. Make sure your master chart is exactly how you want it, because every time you make a change, you'll have to copy paste again with this method.
As far as changing the colors, in the formatting tab (the roller paintbrush above the section you set the filter up) there is an option for Data Colors, and you can edit each visual to be whatever colors you want.
Resident RockstarIt's easy to set up each pie chart to show a different location.
For each pie chart, under the section where you drag the values to be shown, is a section of filters. Set up a visual level filter on location = X for each pie chart. Make sure it's a visual level filter and not a report level filter, or you'll end up with filtered data in all your charts.
I was able to set up the visual filter to show one location at a time. Does this mean I'll have to copy and paste the pie chart and choose a separate location each time?
If that's the case, I can't change the 2 section colors, since the legend is showing per location. Any idea how to fix this?
- Cmcmahan
Yes, copy/pasting the chart and changing the visual level filter is probably the quickest way here. Make sure your master chart is exactly how you want it, because every time you make a change, you'll have to copy paste again with this method.
As far as changing the colors, in the formatting tab (the roller paintbrush above the section you set the filter up) there is an option for Data Colors, and you can edit each visual to be whatever colors you want.