How to modify a chart

Posted on

To modify a chart, mark the chart so that the “CHART TOOLS” appear. Under the “DESIGN” tab, in the Chart Styles Gallery you get a live preview of what your chart will look like with different designs.  I’ll select this dark design which provides better contrast.  You can easily make modifications to your chart using one of the three buttons that now appear next to your chart.

How to modify a chart

The first button gives you options to modify the chart elements, the second button the style and the color of your chart and the third the data selection. I want to add the sales results on top of each column so I’ll click the first button and mark the “Data Label” check box. Then I’ll click the arrow next to the “Axes” and uncheck the “Primary Vertical Axis”. Finally I’ll mark the title and write”2014 Total Sales by Region”. To close down the chart tools click anywhere outside the chart area.