Excel > Charts

Change chart type, switch row/column in Excel

How to change chart type and switch row/column for Excel chart?



In last post, we learnt about Chart axes, legend, data labels and trendline in Excel. In this post, we shall learn how to change chart type, switch rows to column and vice-versa.

Change Chart Type

To change the chart type for chart already built, simply select the chart by clicking and then select 'DESIGN > Change Chart Type' command.

Change chart in Excel

'Change Chart Type' dialog box appears.

Change chart type in MS Excel

Select any chart from left panel on the dialog box and then select it's variance from top. Clicking OK displays the chart in that format. For this example, Line chart.

Line chart in MS Excel

Switch Row/Column in chart

To swap the axis data (X axis data to Y and Y axis data to X), select 'Switch Row/Column' command from 'DESIGN' menu.

Switch row/column in Excel chart

and the axis data is swapped that shows the above chart like this.

Swap axis in Excel chart

Hope you liked this article, do not forget to share and subscribe!

 Views: 292 | Post Order: 42




Write for us