Excel 2007 - Add straight line to chart
 

How would I go about adding a horizontal line to a chart.

I am trying to make a line chart and need to place a horizontal line at 80%
across the entire chart. How can I do this?

QB

Answer: Excel 2007 - Add straight line to chart
 

To add a horizontal line to your chart in Excel 2007, follow these steps:

1. First, create your line chart by selecting your data and clicking on the "Line Chart" option in the "Charts" section of the "Insert" tab.
2. Once your chart is created, click on the data series to which you want to add the horizontal line. This will select the entire series.
3. Right-click on the selected series and choose "Format Data Series" from the drop-down menu.
4. In the "Format Data Series" dialog box, click on the "Line Color" tab.
5. Under "Line Color," choose the "Solid line" option and select a color for your line.
6. Under "Dash type," choose the "Solid line" option.
7. Under "Width," choose a thickness for your line.
8. Under "Transparency," choose "0%".
9. Under "Line Style," choose the "Horizontal line" option.
10. Under "Value," enter the value at which you want your horizontal line to appear (in your case, 80%).
11. Click "OK" to close the "Format Data Series" dialog box.

Your horizontal line should now appear on your chart at the specified value. You can adjust the line's appearance by repeating these steps and changing the line color, thickness, and other settings as desired.

Excel 2007 - Add straight line to chart
 

Insert / Illustrations group / Shapes / Line - draw across at 80% mark.

If my comments have helped please hit Yes.

Thanks.

"QB" wrote:

How would I go about adding a horizontal line to a chart.

I am trying to make a line chart and need to place a horizontal line at 80%
across the entire chart. How can I do this?

QB

Excel 2007 - Add straight line to chart
 

Hi,

Use a dummy series to draw the line.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

On 24/02/2010 01:10, QB wrote:
How would I go about adding a horizontal line to a chart.

I am trying to make a line chart and need to place a horizontal line at 80%
across the entire chart. How can I do this?

QB

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info