Bar chart

[Barry Au]

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

[oldchippy]

Hello there,

It would be better if you could provide a small zipped sample of your worksheet, it would be easier to follow.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.

[Barry Au]

I have attached a sample excel sheet.
The chart in the excel is how I want it. However, that is because I used the values $B$8:$F$9 whereas I want to use $B$11:$F$12 and $B$7:$F$7 to do the same thing because $B$8:$F$9 is not really important to me.

Thanks!

[oldchippy]

Is this what you want?

[Barry Au]

Instead of percentage on the y-axis, i wanted total time spent. I was just hoping to get it look exactly like Chart 1, but without using the dataset $B$8:$F$9

[oldchippy]

Ok, how about this one?