I'm no YouTube expert, but I think the algorithm incentivises 10+ minute videos, probably for the ad time.

I am new to coding and data science as well. I found it useful to find my own original dataset as it also practices the skill of finding and cleaning dataset. I've seen courses recommend to do this as well.

One dataset I created myself was I extracted the metadata from every photo on my computer, e.g. resolution, size and date taken. I then plotted all the data on a graph and tried to determine which camera of mine had taken the picture, from the data.

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.