Formatting Data Series and Markers
Excel provides plenty of options for formatting the appearance of both entire data series and individual markers within a series. We discuss some of these options earlier in this chapter (see Formatting Lines and Borders on page 699 and Formatting Areas on page 701). Here are some more.
Assigning a Series to a Secondary Axis
A secondary value axis makes it possible to compare data series that fall within divergent ranges. The secondary axis, positioned at the right, can have a completely different scale from the primary axis. You can assign as many series as you like to the secondary axis.
Figure 21-15 illustrates the use of a secondary axis. The series showing cost per square foot occupies a range so much smaller ...
Get Microsoft® Excel® 2010 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.
