AchillesFirstStand t1_ir4clip wrote
I am making a sunburst chart in excel, example: https://ppcexpo.com/blog/wp-content/uploads/2022/05/how-to-make-a-sunburst-chart-in-excel.jpg
The chart is to show product sales. The inner ring will be the different customers and the outer ring will be the products sold to each customer.
However, I want each segment to be partially filled depending on what percentage of sales I have achieved so far compared to the total market. For example, if the total market for a widget to customer A is $1m, I want the segment for that widget to be half full if I've achieved $0.5m.
Basically, I want the chart to be able to show progress against a target. It doesn't look like Excel can do this feature. Is there any other platform that can do this or does anyone have any similar ideas?
I just need to show sales progress by product, by customer.
Viewing a single comment thread. View all comments