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.…Another way that you can change the chart is by changing its layout.…