100% Bar chart not in proportion

kmerc1 · #1 09-10-2010, 01:27 AM

I’m using Office 2007, and I am doing a 100% Stacked bar chart. However it is not in proportion.

I need 88%, 4% and 8% in the bar chart but the 8% and the 88% are showing as the same size.

Where do I go to reformat this?

Image is included below

Aravinth · #2 09-27-2010, 06:03 AM

Hi,

I have found out what is wrong with this graph. In this case, I guess that you have entered the % values directly in graph, which should not be done. You need to calculate the % value of the total number and only that value should be entered in each segment of the graph. If you still wanted to display only the numbers 88%, 4% and 8%, you can do that only manually typing those numbers. Hope this helps.

Please respond if there is still any problem.

With regards
Aravinth
aravinthcbe@yahoo.co.in

santidiablo · #3 09-27-2010, 07:46 PM

The solution for me:

I changed the minimum number on the Value Axis to 0.

When I let Excel create the default chart, it started the axis at 80% which is why it makes the stacked bar chart look incorrect.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bar chart help urgent ?????	aligahk06	Excel	1	07-08-2010 12:23 AM
Converting manual chart to bar chart?	aligahk06	Excel	0	07-03-2010 12:23 PM
Bar chart help urgent ?????	aligahk06	Project	0	07-03-2010 06:58 AM
Organization chart	glendot	Word	0	02-23-2010 08:15 AM
Chart fills	derohanes	Excel	1	10-18-2009 06:18 AM