Have you heard of Excel Charts before? Creating a chart in Microsoft Excel is quick and easy. Excel provides a variety of chart types that you can choose from when you create a chart. Excel offers Pie, Line, Bar, and Column charts to name but a few. Showing data in a chart can make it clearer, more interesting and easier to read. Charts can also help you evaluate your data and make comparisons between different values.
- You should have a basic understanding of charts from your elementary schools.
- Be familiar with Pie, Line, Bar, and Column charts and so many of others
In this tutorial, we will learn
- How To insert a charts
- Chart layout and style
- Other chart options such as How to change the chart type, and How to move a chart.
Excel has several different types of charts, allowing you to choose the one that fits your data. In order to use charts effectively, you’ll need to understand how different charts are used. I therefore recommend you to read more about charts online or use good books that will treat it the topic.
1. How to Insert A Chart in Excel Sheet
To properly insert charts in excel, follow the below steps:
- Select the cells you want to chart, including the column titles and row labels. These will be
the source data for the chart.
- From the Insert tab, click the desired Chart command.
- Choose the desired chart type from the drop-down menu.
- The selected chart will be inserted in the worksheet.
NB: If you are not sure of the chart type to use, the Recommended Charts command will
suggest several different charts based on the source data.
2. Excel Chart layout and style
After inserting a chart, there are several things you may want to change about the way your data is displayed. It’s easy to edit a chart’s layout and style from the Design tab.
Excel allows you to add chart elements—such as chart titles, legends, and data labels—to make your chart easier to read.
To add a chart element,
- Click the Add Chart Element command on the Design tab, then
- Choose the desired element from the drop-down menu
- To edit a chart element, like a chart title, simply double-click the placeholder and begin typing.
- If you don’t want to add chart elements individually, you can use one of Excel’s predefined layouts. Simply click the Quick Layout command, then choose the desired layout from the drop-down
- Excel also includes several different chart styles, which allow you to quickly modify the look and
feel of your chart. To change the chart style, select the desired style from the Chart styles group.
3. Other chart options
There are lots of other ways to customize and organize your charts. For example, Excel allows you to rearrange a chart’s data, change the chart type, and even move the chart to a different location in the workbook.
How To switch row and column data
Sometimes you may want to change the way charts group your data. For example, in the chart below, the data are grouped by Age, with columns for each Last Names. However, we could switch the rows and columns so the chart will group the data by Last Names, with columns for each Age. In both cases, the chart contains the same data—it’s just organized differently.
- Select the chart you wish to modify
- From the Design tab, select the Switch Row/Column command.
- The rows and columns will be switched.
Create an excel Data of the form below, thereafter, you carry out the above steps to see it for yourself. I believe this is okay. You are gradually learning, so no need to carry you along like a baby.
To change the chart type
If you find that your data isn’t well suited to a certain chart, it’s easy to switch to a new chart type. In our example, we’ll change our chart from a Column chart to a Line chart.
- From the Design tab, click the Change Chart Type command.
- The Change Chart Type dialog box will appear.
- The selected chart type will appear.
To Move a chart
Whenever you insert a new chart, it will appear as an object on the same worksheet that contains its source data. Alternatively, you can move the chart to a new worksheet to help keep your data organized.
- Select the chart you wish to move.
- Click the Design tab, then select the Move Chart command.
- The Move Chart dialog box will appear. Select the desired location for the chart.
- Click OK.
- The chart will appear in the selected location.