Chart Wizard – Data Series (Step 2 of 3)
Insert > Data > Chart - Step 2
In this step, you specify how the Chart Wizard should read the rows and columns of the table.
Series and categories
First row contains series names
If this check box is selected, the first row of the table (or of the selected cells) will be considered to contain the names of the data series in the rows below it. Otherwise, the first row will be considered as one of the data series.
First column contains category names
If this check box is selected, the first column of the table (or of the selected cells) will be considered to contain X-axis labels. Otherwise, the first column will be considered to contain data values.
X/Y axis
Swap X/Y axis
Swaps the X and Y axes.
Related topics
Chart Properties dialog box – Values tab