How to Format a Chart Line Style in Excel

By eHow Computers Editor

Rate: (0 Ratings)

You can format almost any component of a Microsoft Excel 2007 chart. You can make a big impact on the look of your chart by formatting the line style. You can change the type and width of the line and specify what you want arrows within the chart to look like. Keep reading to find out how you can format a chart line style in Excel.

Flag Article

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

Microsoft Excel 2007

Step1

Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to format the line style of or create a new chart from existing data in a workbook.

Step2

Right-click on top of the line that you would like to format in the chart so you can see a pop-up menu listing several options for formatting your chart.

Step3

Click on "Format (selected item)" to open up the "Format" dialog box. The item in parenthesis is the item that you right-clicked on that you want to format.

Step4

Select "Line Style" from the list of categories on the left side of the "Format" dialog box. The properties for line style will be displayed on the right side of the dialog box.

Step5

Type in a width for the line you have selected in the chart. Use the drop-down picture menus to select what type of compound or dashed line you would like to use. The drop-down list menus will let you specify the cap and join type for the line style.

Step6

Choose any arrow settings you would like to apply in the "Arrow settings" section of the "Format" dialog box. You can use the drop-down picture menus to choose the beginning type of arrow, ending type of arrow, beginning size and ending size.

Step7

Use the "Close" button to close the "Format" dialog box and return to your chart. You will now notice that you have successful formatted the chart line style in Excel.