Chart Wizard Step 2 – Data Series

Specify the data range properly. Adjust the position of the Series and Categories. Decide whether to swap X/Y axis. View the result in the preview window.

Step 2 of creating a chart
  1. In the Chart Wizard – Date Series (Step 2 of 3) dialog box, select First row contains series names and First column contains category names.
  2. In the X/Y axis, if you select Swap X/Y axis, the values of the row and column will be switched.
  3. In the Chart preview, confirm the data and chart appearance. Click Next to move to Chart Wizard Step 3.
Related topics

Adjusting data series

Chart Wizard Step 2 – Data Series