Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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. Again, we are working on the Charts tab of the Ribbon, and here you see that we have the Chart Quick Layouts gallery, and this contains a set of layout templates for each different type of chart.
So, for example, for the bar chart, we have several different layouts that we can choose from. And if we click the Expand button, you will see that there are few more. So I will select a layout where the legend is at the top with the title and we don't have any vertical axis. If I were to go back to the original, which is the first one, you will see that we have vertical lines, and we also have the value labels along the horizontal axis. But now let's say that all I wanted to do was change the location of something inside of the chart, change its layout only slightly.
To do that, you can just click the element that you want to move, for example, here, the Sales legend. I will click it and then move my mouse pointer over the edge, and when the mouse pointer changes to a four-way pointing arrow, that means I can move that element. So I will just click with the left mouse button, drag it up a bit, and there you go. If I wanted to delete the legend, all I will have to do is leave it selected and press the Delete key. After create a chart, you can change everything about it, including its layout or even its type. Keep trying combinations of chart type and layout until you find one you like.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74065 Viewers
80 Video lessons · 129503 Viewers
52 Video lessons · 63827 Viewers
59 Video lessons · 49598 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.