Adding a goal line to an existing graph

[linmar]

Hi,
I have a bar graph created showing various percentages. When I add the goal percentage numbers to the data and add them to the source data, it shows up as an additional column. I would like it to appear as a line across the graph at the appropriate percentage mark. I have done it with a line graph before but don't seem to be able to do it with the bar graph. Thanks!
Linda

 

[GlennUK]

I assume that you mean Column graph and not Bar graph. Select the goal series and change chart type for that series to Line graph

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[HereSomeHow]

Is it possible to add a Vertical line in a Horizontal bar graph?

 

[SkipVought]

Chart > Add trend line.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]