Changing how columns, bars, and lines overlap
The First Row in Front and First Column in Front options let you change how the columns, bars, and lines in your graph overlap: - The First Row in Front option is the most useful when working with column and bar graphs. It affects how the categories, or clusters, of data in a graph overlap when the Cluster Width is greater than 100%. For more information on changing the Cluster Width, see Setting options for column, stacked column, bar, and stacked bar graphs.
- The First Column in Front option is useful when working with column, bar, line and scatter graphs. When this option is selected, the line that corresponds to the first column of data in the Graph Data window is on top; when this option is deselected, the line that corresponds to the last column data in the Graph Data window is on top. This option also determines which column is on top for column and stacked column graphs with a Column Width greater than 100% and for bar and stacked bar graphs with a Bar Width greater than 100%. For more information on changing the Column Width or Bar Width, see Setting options for column, stacked column, bar, and stacked bar graphs.
To change how columns, bars, and lines overlap: - Select a graph with the Selection tool.
- Choose Object > Graph > Type, or double-click the graph tool in the toolbox.
- Select or deselect First Row in Front and First Column in Front as desired, and click OK.
Note: Always select First Column in Front for area graphs; if you do not, some areas may not appear.
|