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

Details

Article ID: 7906
Created
Thu 12/29/22 10:39 AM
Modified
Fri 11/3/23 3:45 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

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.