100% Stacked Column Chart Not Proportional

[jgeddes]

I'm using Excel for Mac, and creating 100% stacked column charts. The data is fairly simple, and most are working out fine. I have a chart for each management team, with the charts showing the number of their team members who've completed required training or not. For example, if there are 8 team members, 7 completed training and 1 has not, then the 100% stacked bar shows 87% completed and 13% have not.

The problem is, some charts are not displaying the series proportionally. To continue the above example, the chart shows about 33% (value=7) have completed and 66% (value=1) have not. It's displaying the correct values, but the corresponding areas are not correct.

The X Axis type is set to Text (the course names). I see no change if I switch Vertical Axis Crosses between Automatic, At Category Number, or At Maximum Category. I can't find how to change the Y Axis Scale. I have Chart Design and Format tabs on my ribbon (not a Layout tab), and on the Format tab, a select list with Chart Area, Horizontal (Category) Axis, Plot Area, etc., but not Y Axis.

Thank you for your help!

 

[pbornemeier]

I don't have Excel on a Mac, but am commenting on the 100% column chart.
Check to make sure all of the numbers you are plotting are numbers and not text. (Copy a 0 value and paste special add on the data). This can be a problem if the data is pasted from another source, or if the data was entered on a "used" worksheet.
Make sure the number formats are all the same and that significant figure can be seen

Try creating the chart on a new worksheet if the problem remains.

You said "some" of the charts are not working well. Enter the data from a chart that is not displaying correctly on a chart that is and see if it is displaying correctly.
The positioning options on the Horizontal and Vertical Axis don't change the scale, but only the position of the axis.
The Y-axis scale is not changeable. It is always 0% to 100%