On the "Spring Sales" worksheet, add the title "New Products" to the column chart. Label the vertical axis "Gross Sales" and the horizontal axis "Months".

1. Highlight the title on the "Spring Sales" worksheet, then type "New Products". 2. You can edit the Font of the title from the mini-toolbar that appears OR from the Home tab. 3. Select the chart elements, in this case it would be "Title", "Vertical Axis", and "Horizontal…

Create charts and objects

Question

On the "Spring Sales" worksheet, add the title "New Products" to the column chart. Label the vertical axis "Gross Sales" and the horizontal axis "Months".

Explanation

Highlight the title on the "Spring Sales" worksheet, then type "New Products".
You can edit the Font of the title from the mini-toolbar that appears OR from the Home tab.
Select the chart elements, in this case it would be "Title", "Vertical Axis", and "Horizontal Axis".
For editing the x-axis which is the horizontal category then type "Months".
For editing the y-axis which is the vertical value then type "Gross Sales".
You can further edit the text of the data in either of the axis as desired.

Topics

#chart title#axis labels#chart formatting#column chart

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice