How to Format Lines in an Excel Chart

by Contributor

You can emphasize the information organized in your chart in Microsoft Excel 2007 by taking some time to format your lines. You can format the line color, line style and shadow for a particular line or set of lines in your chart.

Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you want to format the lines of.

Right-click on top of the line in the Excel chart that you want to format to display the shortcut menu. Choose "Format (name of line)" from the shortcut list. The name of the line you are formatting will appear after the word "Format" in the shortcut list. The "Format" dialog box will open.

Select "Line Color" from the list on the left side of the "Format" dialog box if necessary. The line color options will be displayed on the right side of the dialog box. Choose "Solid line," "Gradient line" or "Automatic" to set the line color. If you choose one of the first two, you will see more formatting options appear. You can then specify the color, transparency and gradient settings for the line.

Click "Line Style" from the list on the left side of the "Format" dialog box. Set the width, compound type, dashed type, cap type and join type using the drop-down lists and boxes. Specify the type of arrow you want to use if applicable in the last part of this section.

Choose the "Shadow" option on the left side of the dialog box to display the shadow settings for the line. Choose a shadow from the preset shadows and set the color. Use the sliders to set the transparency, size, blue, angle and distance of the shadow.

Click the "Close" button to close the "Format" dialog box and save your settings. You will return to your Excel chart with your newly-formatted lines visible.

Items you will need