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. To get to the formatting dialog box, double-click a member of the series. In ...

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.