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.
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 Type' dialog box appears.
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.
To swap the axis data (X axis data to Y and Y axis data to X), select 'Switch Row/Column' command from 'DESIGN' menu.
and the axis data is swapped that shows the above chart like this.
Hope you liked this article, do not forget to share and subscribe!Views: 292 | Post Order: 42