Formatting Data Series and Markers

Excel provides plenty of options for formatting the appearance and arrangement of both entire data series and individual markers within a series. Many of these options apply to all charts, whereas others are for specific chart types. You'll look at the generally applicable options first, followed by options for specific chart types.

Tip Format markers individually

You can apply many formatting options to data markers both singularly and as a whole series. To select a single marker, first select its series. Then click the marker you want to format. If Excel cannot apply your formatting command to the individual marker, it applies it to the entire series.

Assigning a Series to a Secondary Value Axis

A secondary value ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.