Hi all,

I'm new to this forum and I am seeing a lot of helpful information.

I have a question and considering I'm only basic with Excel, please bear with me.

I'm currently trying to create an excel chart that shows the productivity of a team by showing "Time spent on high-value(HV) tasks vs low-value(LV) tasks"

On y-axis: Total time spent (in hours)
On x-axis: Months (in month)

for example: say in January, time spent on HV tasks is 100hrs, and LV task is 180hrs. HV tasks completed is 60, and 80 for LV tasks.

I'm trying to create a stacked bar chart having the bar showing total time spent (in this example it is 100+180=280hrs). But for that bar, I want 57.45% of the bar showing time spent on LV tasks and the remaining 42.55% showing the time spent on HV tasks.

At the moment, I can only create a stacked bar chart showing 280hrs, and it is split between 100hrs and 180hrs.

Your suggestions is appreciate.

Regards,
Barry