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 course and it covers the different ways in which you can insert a chart using your data.Inserting Excel Charts: Excel icon 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 Excel charts, why not take a look at our previous one on custom animation in PowerPoint?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy