How can I switch the axis in Numbers?
I have a numbers chart with dates on the y axis and costs on the x axis. How do I change them around and how do I edit the dates on the x axis?
[Re-Titled by Moderator]
iMac 27″ 5K, macOS 13.6
It's important to know what kind of chart. And what your data table looks like.
If you have an X-Y Scatter chart where there is no Header Column in the table then you can switch the x and y by clicking in the chart and going here and "switching" the X Value and Y Value range references.
Click each address token, click again to select it, and then select the range in the table that you want. When the range you want is displayed (Numbers enters it automatically) then click the green checkmark.
However, if you have Date on the left and Cost on the right the chart should display with dates across the x-axis by default.
If you have a Line or other "category" chart, and you want the dates across the bottom on the x-axis then set up the table so the dates are in a Header Column (on the left, which will display as shaded). When you select the cells in the table and insert a chart it should display as you want it.
If you haven't done so already be sure to have a look at the 'Charting Basics' template at File > New in the menu for working examples. Also have a look at the User Guide at Help > Numbers Help in the menu.
SG