Changing chart types and layouts


show more Changing chart types and layouts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Changing chart types and layouts

One of the great things about creating charts in Excel is that you can summarize many data sets using more than one type of chart. If the first chart type you select doesn't work, you can try another one. If all you want to do is change the chart's layout, such as by moving or removing the title, you can select from one of several pre-made layouts, or delete or move individual elements yourself. Now in this worksheet, I already have a column chart. If I want to change this chart's chart type, I don't need to delete it and create a new chart; instead, all I need to do is on the Charts tab of the Ribbon go to the Change Chart Type area and select a new type of chart.

So let's say that I want to display this data using a pie chart. I will click Pie, select a two- dimensional pie, and Excel displays that chart. If I wanted to create a bar chart, I could do that the same way. Make sure the chart is still selected, click Bar, click the type that I want, and there is my chart. A...

Changing chart types and layouts
Video duration: 2m 22s 6h 32m Beginner

Viewers:

Changing chart types and layouts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...