How To Use Excel Charts

Select insert recommended charts.

How to use excel charts. To create a chart follow these steps. You can also draw charts to compare set targets against actual achievements. We will use the following data for this tutorial. If the preview looks good then press ok. Include any cells that contain text labels that should be in the chart too.

Open excel and select new workbook. In this section we ll show you how to chart data in excel 2016. Depending on your data excel will insert either a value or category map. We will be using excel 2013. Enter data into a worksheet.

Using charts you can easily tell which year had the most sales and which year had the least. I used the shortcut to insert the chart. Select the data to include on the chart. You begin making your gantt chart in excel by setting up a usual stacked bar chart. Use these map charts whenever you have data is sort of geographical regions such as countries continents city state postal codes county etc.

Charts are usually used to analyse trends and patterns in data sets. Right click inside the box and choose format axis from the popup menu. If you have a lower version then some of the more advanced features may not be. Now it s time to create a map chart so select any cell within the data range then go to the insert tab charts maps filled map. The default chart looks like this.

If you don t see a chart you like select the all charts tab to see all chart types. Open the excel file that holds the chart from which you want to exclude dates. 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. 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.