O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required