Inserting Excel Charts – how do I create a chart in Excel? Watch the video to learn more
This week’s hint and tip is about how to insert a chart within Excel. This is on our Intermediate Excel training course and it covers the different ways in which you can insert a chart using your data. We are going to go through it now below.
Different ways to insert a chart in Excel
In the video below we demonstrate three ways in which you can insert a chart in Excel. There isn’t a reason for one being better than the other, it is mainly down to personal preference. The three ways are as follows: using the Insert Tab, using the Quick Analysis option and the F11 button.
Insert Tab
Firstly, select all the data in your worksheet. Next go to the Insert Tab in Excel and look for the Charts gallery along the ribbon. Here you will find a range of types of charts that you can choose from. Select the chart you want and it will then insert the chart into the worksheet you are in with your data.
Quick Analysis button
Firstly, select all the data in your worksheet. Once you have selected it, you will notice a small button appear in the bottom right hand corner of your selected data. This is your Quick Analysis option. If you click on this button, you will see a heading for Charts. When you click on this some chart types will appear that you can choose from. Select one of these and it will insert the chart into the worksheet you are in. If there isn’t one that you want shown, select the option for more and it will give you more types to choose from.
F11 button
Firstly, select all the data in your worksheet. Once you have selected it, press the F11 key on your keyboard. It should create your chart straight away. If it doesn’t, you might need to press the function key first to activate the F11 key on your keyboard. The function key is the ‘Fn’ key found in the bottom left hand corner of your keyboard. Press this once and then press the F11 key again, it should now create your chart for you. It will create your chart in a separate sheet and as a column chart by default.
The video below shows you how to insert a chart in Excel. Charts are a powerful tool in Excel as they can display your data in a simple and easy way which are great for presenting to others.
Take a look below at the video to find out more and then try it out on your own computer!
We hope you have enjoyed this hint and tip on inserting charts in Excel, why not take a look at our previous one on custom animation in PowerPoint?