Bar Chart

[Guest]

Hi All

I have a bar chart with different percentages displayed as the columns. Or
target is 70%. Is it possible to have a target line added to the bar chart to
show how many meet the target?

In a line graph I just add a target column to create the target line but
this will not work with a bar chart

Any help greatly appreciated

Kind regards

Rexmann

 

[Guest]

opps forgot to say using Excel 2003

 

[Andy Pope]

Hi,

Details can be found here.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

 

[Guest]

Hi Andy

Nice one, sorted my problem

Cheers rexmann