Bar chart

**Barry Au** · 05-04-2007, 01:03 PM

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** · 05-04-2007, 04:46 PM

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** · 05-04-2007, 06:35 PM

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** · 05-04-2007, 06:48 PM

Is this what you want?

**Barry Au** · 05-04-2007, 07:40 PM

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** · 05-05-2007, 04:09 PM

Ok, how about this one?

**Barry Au** · 05-07-2007, 08:53 AM

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.

**oldchippy** · 05-07-2007, 04:58 PM

This is what I did.

Click the High Value Column on the chart, right click Format > Data Labels > Value, that puts the contents of B9:F9 on the chart. Format these values to %.

Click the first one, then click again to select just that one, whipe through the value in the text box to select it, then put your cursor in the formula bar, press = , then select B12.

You should now have 86% on the first column. Repeat this process for the remainder, selecting the appropiate values.

Hope I've explained this OK, any questions please ask.