Target line to a column chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deb - 14 Sep 2007 00:54 GMT

I have a column chart with 0 - 100% "X" axis with gridlines at every 20%. I
need to add a "target" line at 95% to show performance goal. How do I do this?

Reply to this Message

Andy Pope - 14 Sep 2007 12:45 GMT

Hi,

Have a look at Jon's page,
http://peltiertech.com/Excel/Charts/AddLine.html

Cheers
Andy

Signature

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

>I have a column chart with 0 - 100% "X" axis with gridlines at every 20%.
>I
> need to add a "target" line at 95% to show performance goal. How do I do
> this?

Reply to this Message

Bernard Liengme - 14 Sep 2007 12:50 GMT

See
http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html
note the links at the bottom of this page for other methods
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I have a column chart with 0 - 100% "X" axis with gridlines at every 20%.
>I
> need to add a "target" line at 95% to show performance goal. How do I do
> this?

Reply to this Message