A new chart can also be inserted without having to highlight your data beforehand.
To do this, go to an empty cell.
Go to the Insert tab, and under Charts, select a type you prefer.
In this example, I will be using a column chart.
After selecting a chart type, you will notice that it is an empty canvas.
This is because there is no data selected.
Notice that in general, when a new chart is inserted more features are made available.
This is found in the Chart Tools tab.
In Excel 2013 and 2016, there are two tabs: Design and Format.
There are multiple ways to introduce the data to the empty chart:
- Select the empty chart and go to the Design tab under Chart Tools. Under Design tab, click on Select Data.
2. Another way is to right click on the empty chart and select Select Data.
Once you are in the Select Data window, you will need to specify your chart values. There are also different ways to do this:
- Under Legend Entries (Series), click on Add.
The Edit Series window will ask you to specify the different elements of the chart.
For Series name, you can either hardcode the name or you can do a cell reference to the table header, B5.
For Series values, highlight the values in the data table.
After adding the series values, you will notice that the labels (A6:A10) are not yet displayed on the chart.
To add these, click on Edit under the Horizontal (Category) Axis Labels.
In this window, you can add new series, edit the existing series or remove them.
2) Instead of adding the series details one by one, you can also just specify a Chart data range by selecting the text box and highlighting your data table.
In this case, A5:B10.
Excel figures out where to plot the given data range and generates a chart.