Microsoft Office Tutorials and References
In Depth Information
Basic series formatting
You can apply formatting to the entire series or to a single data point within the
series — for example, make one column a different color to draw attention to it.
Basic series formatting
Basic series formatting is very straightforward: Just select the data series in your chart,
access the Format Data Series dialog, select the Patterns tab, and make your changes.
Figure 4-11 shows a “chart makeover.” The top chart is a simple combination
chart, with default formatting for the two data series. Although the chart serves its
purpose, most would agree that the bottom chart — which is the result of about two
minutes of formatting work — is a significant improvement.
Figure 4-11: A combination chart, before and after applying
some simple formatting
Following is a list of the simple changes made to this chart, using the Format
Data Series dialog box:
For the Projected series, the line color was changed to red, the line weight
was increased, the Marker style was changed, and the marker foreground
and background colors were set to match the line color. In addition, the
marker size was increased and a shadow was added.
For the Actual series, a gradient was added (using the Fill Effects dialog
box) and the gap width was decreased (using the Options tab of the
Format Data Series dialog box).
Search JabSto ::




Custom Search