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 discussed some of these options earlier in this chapter (see "Formatting Lines and Borders" and "Formatting Areas"). Here you’ll look at a couple 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 on 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 20-15 illustrates the use of a secondary axis. The series showing cost per square foot occupies a range so much smaller ...
Get Microsoft® Office Excel® 2007 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.