I do not use charts very often and forget how to do them year to year. Here I have bins of items: a, b, c, and d. The numbers change by year. I am trying to create a stacked bar chart with a, b, c, and d stacked on top of each other and the year as the Y axis. I have tried transposing and it did not help. Please help. I need a step-by-step process of what to select.
iMac 27″ 5K, macOS 13.2
When you create a chart, Numbers assumes whichever you have more of (rows or columns) in your selection of data for the chart is the way the data is arranged. For example, if you have more rows than columns it assumes each column is a series. Similarly, if you have more columns than rows it assumes each row is a series. That is sometimes not correct.
Click on the chart. At the bottom left corner of the screen is "plot rows as series". Switch it to "plot columns as series".
Table has a header row and a header column
Select the cells in the table
Click the Chart icon in the toolbar
Choose a stacked bar chart (not stacked column)
I just tried that. The stacked bar chart displays the same erroneous chart. When I do that the ROWS in the table are highlighted (not the columns). In another, smaller, test table I can get it to work. But in that case the columns are highlighted. Please help.
Help stacked bar chart
