Hi Suzan,
Yes, it is definitely possible to use the values in column 1 as the x-axis values in a scatter chart. Here's how you can do it:
- Select the data range that you want to use for the chart, including the column 1 values that you want to use as the x-axis values.
- Click on the "Insert" tab in the ribbon at the top of the Excel window.
- Click on the "Scatter" chart type in the "Charts" section of the ribbon.
- Excel will automatically create a scatter chart with the default x-axis and y-axis values. To change the x-axis values to the values in column 1, right-click on the chart and select "Select Data" from the context menu.
- In the "Select Data Source" dialog box, click on the "Edit" button next to the "Horizontal (Category) Axis Labels" field.
- In the "Axis Labels" dialog box, select the range of values in column 1 that you want to use as the x-axis labels. You can either type in the range manually or use the mouse to select the range.
- Click "OK" to close the "Axis Labels" dialog box, and then click "OK" again to close the "Select Data Source" dialog box.
Your scatter chart should now have the values in column 1 as the x-axis values. If you need to make any further adjustments to the chart, you can use the various formatting and layout options in the
"Chart Tools" section of the ribbon.