Excel: 100% Stack Bar Chart, the bars are not plotting correct for few combination of values

excel charts ms-office excel-charts
Kashif picture Kashif · Dec 13, 2016 · Viewed 10.4k times · Source

Please look at the image below: How can orange bar in the first chart be that big. This pattern repeats even if I make both values half like 105, 21 or 53, 10 etc.

enter image description here

As soon as value is value is 43 the chart starts behaving fine.

Thanks.

Answer

elmer007 picture elmer007 · Dec 13, 2016

Excel is changing the axis (that you don't have displayed) automatically to what it thinks is a relevant range. However, this range is probably something like 75% to 100% as in the following picture (with the axis displayed):

enter image description here

While this seems to not make sense for the purpose of a 100% stacked bar chart, this is nonetheless what Excel tries to do.

To fix it, go to Primary Horizontal Axis options and change the Minimum from "Auto" to "Fixed" and set the value to 0. You might also want to set the Maximum to "Fixed" and set the value to 1. See options pictured below:

enter image description here

Related questions

Swap x and y axis without manually swapping values

So I have a set of data that has conditional formatting. Basically it's a set of photometric measurements of stars that I want to put on a chart with different colors for stars in different ranges of Color Index (basically …

Read More
Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to series n. Say, I want to move …

Read More
How can I color dots in a xy scatterplot according to column value?

Consider the following worksheet: A B C D 1 COMPANY XVALUE YVALUE GROUP 2 Apple 45 35 red 3 Xerox 45 38 red 4 KMart 63 50 orange 5 Exxon 53 59 green I have used the scatterplot function in Excel to create the following chart: However, each point in the chart has …

Read More