Change the Chart View in Excel

Question

How do I change chart views in Excel?

Answer

You can do more with your data than create one chart. You can make your chart compare data another way by clicking a button to switch the chart view from one view to another.

But another way to look at the data is to compare sales for each salesperson, month over month. To create this view of the chart, click Switch Row/Column in the Data group on the Design tab. In the chart on the right, data is grouped by rows and compares worksheet columns. Now the chart says something different: It shows how each salesperson did, month by month compared against themselves.

You can Switch the chart back to the original view by clicking Switch Row/Column again.

For more information about Charts and Graphs in Excel, please view the full tutorial from the CTL here: Excel Part 2

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.