CODEWITHSUNDEEP
reporting-servicespie-chart
aperture
aperture

Reputation: 53

How to Group Multiple Datasets in Pie Chart Legend?

I currently have a pie chart that is taking from a dataset 1 and displaying the result rows.

What I would like to add is a second and third dataset, dataset 2 and dataset 3, to add to the legend of the pie chart, but not the actual displayed chart.

Example: Dataset 1 contains apples 50% and oranges 50% Dataset 2 contains different apples adding up to 50% Dataset 3 contains different oranges adding up to 50%.

Picture of intended output:

Oranges and Apples pie chart with nested dataset legend

Is there a way to modify that legend to allow different datasets to not impact the pie chart?

Upvotes: 0

Views: 707

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

Remove the legend, size the chart so it is on one side of the report and put a table on the other side. The table becomes the legend replacement and is just a normal report with grouping on Apples and Oranges and detail rows of their different types.

You may want to manually set the colouring of the chart sections and display those colours in the table if you want it to look like an actual legend. I discuss an easy way to do this in this answer.

Upvotes: 1

Related Questions