Plot data series from datasheet rows instead of columns, and vice versa

You can tell whether data series are from rows or columns by looking at the row headings and column headings on the datasheet. A graphic that represents the chart type appears in the heading of a row or column.

  • To have the columns on the datasheet represent the data series in the chart, click By Column Button image on the Standard toolbar.

  • To have the rows on the datasheet represent the data series in the chart, click By Row Button image on the Standard toolbar.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×