Forum Discussion
graph
Click anywhere on the chart.
On the Chart Design tab of the ribbon, click Select Data.
For a XY Scatter chart, select a series, then click Edit. Clear the x-values box, then point to the range containing the x-values that you want to use.
For other chart types, click Edit under 'Horizontal (Category) Axis Labels', clear the box, then point to the range containing the x-values that you want to use.
Thanks very much. BUT: when I click anywhere on the chart, no CHART DESIGN tab comes up on the ribbon on the top, so I can't "Select Data".
Which version of Excel are you using?
- The desktop version for Windows
- The desktop version for Mac
- The iOS app
- The Android app
- The web (browser) version
I am using Desktop for Windows.
The ribbon looks like this:
Thanks - as far as I can tell, that screenshot is from Excel Online (the browser version), not the desktop version.
This is the ribbon in the desktop version of Excel (in Microsoft 365):
And in the online/browser version:
...so if you could help me solve that issue, I would be most grateful.