Apple Intelligence is now available on iPhone, iPad, and Mac!
My spreadsheet has 3 columns of data. I want to make a bar chart with Column B as the abscissa and Column C the values. By default the chart selects Column A as the abscissa. I am unable to figure out how to force Column B as the abscissa. Any ideas how to force Column B to be the abscissa?
Thank you
For a bar chart or any of the category charts (not scatter chart), make the chart using column C as the Y data. It will, as you said, use column A for the X axis labels if column A is a header column. The labels will all be "untitled" if the column A is not a header column. Select the chart and go to the X-Axis settings. There is a box there for Label References. Click on it then use Command A to select all the cell references. Delete. While still in the box, go to your table and select the range of X labels in column B. When you hit Enter or the green checkmark, it will break it down into individual cell references like what you saw before.
After:
For a bar chart or any of the category charts (not scatter chart), make the chart using column C as the Y data. It will, as you said, use column A for the X axis labels if column A is a header column. The labels will all be "untitled" if the column A is not a header column. Select the chart and go to the X-Axis settings. There is a box there for Label References. Click on it then use Command A to select all the cell references. Delete. While still in the box, go to your table and select the range of X labels in column B. When you hit Enter or the green checkmark, it will break it down into individual cell references like what you saw before.
After:
On way is to do this:
Select the columns:
Go to the menu:
Result:
SG
Need a different olumn for abscissa
