How To Use Excel Charts

Let s say you have been recording the sales figures in excel for the past three years.

How to use excel charts. Click axis options on the left side of the format axis window. The default chart looks like this. Open the excel file that holds the chart from which you want to exclude dates. We will use the following data for this tutorial. Or you can go to insert charts and insert a chart of your choice.

Include any cells that contain text labels that should be in the chart too. If you don t see a chart you like select the all charts tab to see all chart types. If so hold down the ctrl key while you select the cells you want. You may need to select a range of cells that don t touch each other noncontiguous for step 1. 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.

Switch to the insert tab charts group and click bar. To create a chart follow these steps. Select insert recommended charts. Enter data into a worksheet. Select the data to include on the chart.

Use these map charts whenever you have data is sort of geographical regions such as countries continents city state postal codes county etc. You can also draw charts to compare set targets against actual achievements. If the preview looks good then press ok. We will be using excel 2013. Now select this data and press the ctrl f1 to shortcut to insert a default embedded chart in excel.

Charts are usually used to analyse trends and patterns in data sets. Enter the data you want to use to create a graph or chart. Using charts you can easily tell which year had the most sales and which year had the least. If you have a lower version then some of the more advanced features may not be. Open excel and select new workbook.