Forum Discussion
Need Help with Pie of Pie Chart
seanoreilly With some extra steps you can recreate such a pie chart, as demonstrated in the attached file, although I'm not sure if there isn't a smarter way to do it.
The 20% for customer 2 needs to be split in two parts based on the cash/card ratio (i.e. 14 and 6) so that you get 3 data points for the customers, of which the last 2 will be used to create the 2nd pie.
The label names are concatenated from the customer (or payment type) and value fields, and linked to each label by entering the reference in the formula bar.
seanoreilly With some extra steps you can recreate such a pie chart, as demonstrated in the attached file, although I'm not sure if there isn't a smarter way to do it.
The 20% for customer 2 needs to be split in two parts based on the cash/card ratio (i.e. 14 and 6) so that you get 3 data points for the customers, of which the last 2 will be used to create the 2nd pie.
The label names are concatenated from the customer (or payment type) and value fields, and linked to each label by entering the reference in the formula bar.
Thanks Riny_van_Eekelen - that is very helpful and exactly what i was looking for.