Formatting Lines and Borders
Excel uses lines for axes, line charts, and trendlines. It also uses lines to create borders around a variety of chart elements—the chart area, the plot area, the titles, the legends, the markers on bar and column charts, and so on. Not all of these borders appear by default (for example, chart titles are borderless by default), but all are available if you want them.
The formatting options for all the lines and borders are essentially the same. You can color them, fatten them, change them from solid to dotted or dashed, and so on. (You can also delete them.)
For example, suppose you want to change the color of a series line on a line chart. The element you want to format is called Series 1 (assuming it’s the first data ...
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.
