Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
76
Views
Topic starter
Is it possible to have in the "Sales by Category" on each category the same colour as in the other charts used for each category?
Posted : 01/12/2020 8:50 am
Hi Alex,
With Pivot Charts this isn't possible, but you could use a regular chart to plot each category as a different series and then format each series a different colour. This video explains how to create a regular chart from a PivotTable. You'll need to extract each category into a separate column so that it's recognised as a different series.
See how you get on and come back with an example file if you get stuck.
Mynda
Posted : 01/12/2020 6:45 pm
