Bar Chart
 

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

Bar Chart
 

opps forgot to say using Excel 2003

"rexmann" wrote:

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

Bar Chart
 

Hi,

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

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rexmann" wrote in message
...
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

Bar Chart
 

Hi Andy

Nice one, sorted my problem

Cheers rexmann



"Andy Pope" wrote:

Hi,

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

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rexmann" wrote in message
...
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