How To Use Excel Charts

If so hold down the ctrl key while you select the cells you want.

How to use excel charts. 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. Open excel and select new workbook. If you don t see a chart you like select the all charts tab to see all chart types. You begin making your gantt chart in excel by setting up a usual stacked bar chart. Select a chart on the recommended charts tab to preview the chart.

Or you can go to insert charts and insert a chart of your choice. Select insert recommended charts. You can also draw charts to compare set targets against actual achievements. Using charts you can easily tell which year had the most sales and which year had the least. Enter the data you want to use to create a graph or chart.

Click the x axis located underneath the chart so that it becomes surrounded by a small box. Switch to the insert tab charts group and click bar. To generate a chart or graph in excel you must first provide excel with data to pull from. Enter data into a worksheet. I used the shortcut to insert the chart.

We will be using excel 2013. If the preview looks good then press ok. To create a chart follow these steps. 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. Select a range of your start dates with the column header it s b1 b11 in our case.

Depending on your data excel will insert either a value or category map. We will use the following data for this tutorial. Now select this data and press the ctrl f1 to shortcut to insert a default embedded chart in excel. Let s say you have been recording the sales figures in excel for the past three years. Now we can use excel maps to generate fancy maps and map charts for such type of data and that too within a jiffy when your data is ready.