Insert and edit charts in Excel
The following article details you how to insert and edit charts in Excel 2013.
Insert and edit charts in Excel Picture 1
To insert a chart, follow these steps:
Step 1: Select the data to create a chart. The example here wants to create a sales chart of the employees. Go to the Insert tab -> illustration -> Chart -> select the type of chart you want to create:
Insert and edit charts in Excel Picture 2
Step 2: After selecting the chart type -> data has been shown on the chart:
Insert and edit charts in Excel Picture 3
Step 3: After creating the chart, you need to adjust the chart to look better and more intuitive. Click on the chart -> click on the Chart Element icon to customize the components in the chart:
Insert and edit charts in Excel Picture 4
- For example, when selecting the Data Labels icon -> the quantity value is displayed corresponding to the columns on the chart:
Insert and edit charts in Excel Picture 5
- Or when selecting a Legend chart again:
Insert and edit charts in Excel Picture 6
Step 4: Change the chart style -> click on the chart -> select the Chart Style icon on the chart to re-select the chart style and color for the chart:
Insert and edit charts in Excel Picture 7
Step 5: Excel 2013 supports additional filtering features on the chart -> click on the chart -> select the Chart Filters icon -> precursor filter data by ticking on the items as shown:
Insert and edit charts in Excel Picture 8
- Or you can filter data by name by selecting the Names tab .
Insert and edit charts in Excel Picture 9
- So just a few simple operations you have created the chart:
Insert and edit charts in Excel Picture 10
Above is detailed instructions for inserting and editing charts in Excel 2013.
Good luck!
You should read it
- How to draw a map chart on Excel
- Insert and edit charts in Word
- How to fix chart position in Excel
- Instructions on how to create charts in Excel professional
- How to draw charts in Excel
- MS PowerPoint 2007 - Lesson 7: Insert images and graphics in the slide
- Insert and edit flowcharts (SmartArt) in Excel
- How to create 2 Excel charts on the same image
- Create and insert Word 2016 charts
- How to draw a pie chart in Excel 2016
- Instructions for inserting a PDF file into Excel spreadsheet
- Insert and edit Word Art in Excel