How To Use Excel Charts

Select a chart on the recommended charts tab to preview the chart.

How to use excel charts. Click the x axis located underneath the chart so that it becomes surrounded by a small box. The default chart looks like this. Charts are usually used to analyse trends and patterns in data sets. To create a chart follow these steps. To generate a chart or graph in excel you must first provide excel with data to pull from.

We will use the following data for this tutorial. You can select the data you want in the chart and press alt f1 to create a chart immediately but it might not be the best chart for the data. Select the data to include on the chart. If so hold down the ctrl key while you select the cells you want. Use these map charts whenever you have data is sort of geographical regions such as countries continents city state postal codes county etc.

Let s say you have been recording the sales figures in excel for the past three years. Enter the data you want to use to create a graph or chart. Now select this data and press the ctrl f1 to shortcut to insert a default embedded chart in excel. You can also draw charts to compare set targets against actual achievements. You begin making your gantt chart in excel by setting up a usual stacked bar chart.

Depending on your data excel will insert either a value or category map. Open excel and select new workbook. In this section we ll show you how to chart data in excel 2016. Select a range of your start dates with the column header it s b1 b11 in our case. You may need to select a range of cells that don t touch each other noncontiguous for step 1.

Combination chart or most commonly known as combo chart in excel is a combination of two or more than two different charts in excel to make such types of combo charts we can use the option of creating a combo chart from the insert menu in the chart tab also in order to combine two charts we must have two different data sets but one common field to combine. Click axis options on the left side of the format axis window. Or you can go to insert charts and insert a chart of your choice. Right click inside the box and choose format axis from the popup menu. Select insert recommended charts.