Change the way data is plotted
From Microsoft Graph
Change the way data is plotted
You can change the placement and datasheet orientation of data series in a chart. The order in which Microsoft Graph plots data series in the chart is determined by their order on the datasheet.
What do you want to do?
Plot data series from datasheet rows instead of columns, and vice versa
Plot a data series along a secondary value axis in a 2-D chart
Reverse the plotting order of categories, values, or series
Control the way empty cells are plotted
Change which row or column contains the x axis values for an xy (scatter) chart