On the "Summer Sales" worksheet, add the "Total" data series to the "Top Sellers" column chart. Include the total only for "Fruits", "Vegetables", and "Jams & Honey".

1. Select the "Top Sellers" column chart. 2. Click on Add Chart Element + , from the upper right corner next to the chart, then select Data Labels. 3. From the dialog box for the Data Label, from the data range which are the cell values you want to appear in the labels, in this…

Create charts and objects

Question

On the "Summer Sales" worksheet, add the "Total" data series to the "Top Sellers" column chart. Include the total only for "Fruits", "Vegetables", and "Jams & Honey".

Explanation

Select the "Top Sellers" column chart.
Click on Add Chart Element + , from the upper right corner next to the chart, then select Data Labels.
From the dialog box for the Data Label, from the data range which are the cell values you want to appear in the labels, in this case it would be the "Total" column for the Fruits, Vegetables, and Jams & Honey. Then click OK.
You can further edit the text of the data in either of the axis as desired.

Topics

#data series#chart editing#column chart#add series

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice