• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 6. Working with Charts > Altering Chart Options

Altering Chart Options

Right-click the plot area and select Chart Options from the shortcut menu that appears.

The Chart Options dialog box opens. Type any changes to the chart titles on the Titles tab.

Click the Axes tab and select from the Primary axis options to see how altering these settings affects your chart.

Click the Gridlines tab and select from the various major gridlines and minor gridlines for each of the Category, Series, and Value axes.

INTRODUCTION

Changing your chart options can be as much fun as creating the chart in the first place. You can add or edit chart titles, alter your axes, add or remove gridlines, move or delete your legend, add or remove data labels, and even show the data table containing your original data.


TIP

Double-clicking the chart

One of the fastest ways to edit charting options is to double-click directly on the element in the chart you want to alter. The appropriate dialog box opens, enabling you to make the changes you need.


TIP

Formatting the axes gridlines

To change the pattern and scale of the gridlines, double-click the gridline itself. Then use the Format Gridlines dialog box to make your selections. Click OK.


Click the Legend tab, select whether you want to show a legend, and review how altering the Placement options affects your chart.

Click the Data Labels tab and see how the addition of label descriptions affects your chart.

Click the Data Table tab and select whether you want to show the data table (with or without the legend keys). When you're finished, click OK.

Review how your chart has changed.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint