Adding visual emphasis to graphs
You can refine the look of a graph using visual aids, including drop shadows, adding legends at the top of the graph, or overlapping the columns in a bar graph.
To add a drop shadow: In the Graph Type dialog box, select Add Drop Shadow and click OK. Graph with drop shadows
To display legends across the top of a graph: - In the Graph Type dialog box, select Add Legend Across Top.
- Click OK. By default, legends are displayed to the right of the graph. You can choose to display them horizontally across the top of the graph.
Graph with default legends compared to graph with legends across top.
To make columns or bars of data overlap: - When creating a stacked column or stacked bar graph, in the Graph Type dialog box enter a value in the Column Width or Bar Width text box greater than 100%.
- Select First Column in Front, and click OK.
Graph with overlapping columns
To specify the order in which columns overlap: - In the Graph Type dialog box, to place the first row or column of data in the work sheet frontmost in the graph, select First Row in Front or First Column in Front (the default). You must always select this option for an area graph; if you do not, some areas may not appear.
- Click OK.
|