Thread: Bar chart

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

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!

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

thanks oldchippy!

just like how i wanted it.
the question is, how did you do it?

How did you display the % on the chart?

i try to go format data series and select 'Value' under data label and it only shows the numbers, not the percentages.

thanks for your help.

thanks chippy! got it.
you've been great help.
thanks for your time.