Current location - Quotes Website - Personality signature - When making bar charts with excel, how to label each bar with corresponding data?
When making bar charts with excel, how to label each bar with corresponding data?
1. First, open the excel table, enter the data needed to make a statistical chart in the table, and select the cells with data.

2. Click Insert Chart in the toolbar and select the appropriate statistical chart mode. Select a two-dimensional column chart here.

3. After selecting the page, you can insert the icon corresponding to the data, and you can see that no data is displayed on the chart at this time.

4. Select a color graphic, click the right mouse button, and click "Add Data Label" in the pop-up option summary.

5. You can add corresponding data to the top of each chart.