Charts
There are many different kinds of charts you can create, such as bar, pie, and so on. Some charts suit different types of data better than others:
- Pie Charts show a comparison of the elements to the whole, such as a company's monthly budget
- Line Charts show a trend/trends over time, such as monitoring a stock in the stock market for a year
- Bar Charts can be used to compare a couple pieces of data separated into different groups, such as shipping expenses a company has accumulated over 3 different days from 4 different companies like our example
- Creating a chart
- Editing the chart
Creating a Chart
To create a chart:- Highlight a range of cells, such A3:E8
- Go to the Insert tab, and click the drop down arrow to see your chart options
- Click on a chart type, such as clustered column
- You will create a chart that looks like this:
Editing the Chart Information
All of your chart editing options can be found by clicking on the chart and then clicking the "chart" tab:
- To change the title of the chart, double click on the title or select "edit chart title" from the chart options, and enter a new one
- To change the axis titles, select the Axis Titles dropdown, select which axis you want to give a title, and then provide one
- To edit series names and other things, you can click the format option, select which series you want to edit, and set a name and other font properties
- Gridlines are lines along the axis values to help line up information. To add gridlines, select the gridlines option and pick which type of gridline you would like to add
Once you have made these modifications, you could end up with a chart that looks something like this: