#1
|
|||
|
|||
100% Bar chart not in proportion
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 |
#2
|
|||
|
|||
Graph values
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 |
#3
|
|||
|
|||
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 |