How To Use Excel Charts

Enter data into a worksheet.

How to use excel charts. Select insert recommended charts. Be sure to select only the cells with data and not the entire column. If you don t see a chart you like select the all charts tab to see all chart types. Charts are usually used to analyse trends and patterns in data sets. To generate a chart or graph in excel you must first provide excel with data to pull from.

Open excel and select new workbook. Use these map charts whenever you have data is sort of geographical regions such as countries continents city state postal codes county etc. You begin making your gantt chart in excel by setting up a usual stacked bar chart. Enter the data you want to use to create a graph or chart. Let s say you have been recording the sales figures in excel for the past three years.

Now select this data and press the ctrl f1 to shortcut to insert a default embedded chart in excel. You may need to select a range of cells that don t touch each other noncontiguous for step 1. If so hold down the ctrl key while you select the cells you want. Click the x axis located underneath the chart so that it becomes surrounded by a small box. We will be using excel 2013.

If the preview looks good then press ok. Open the excel file that holds the chart from which you want to exclude dates. If you have a lower version then some of the more advanced features may not be. Select a chart on the recommended charts tab to preview the chart. To create a chart follow these steps.

The default chart looks like this. 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. Include any cells that contain text labels that should be in the chart too. Switch to the insert tab charts group and click bar. Select the data to include on the chart.