ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Target line to a column chart? (https://www.excelbanter.com/charts-charting-excel/158225-target-line-column-chart.html)

Deb

Target line to a column chart?
 
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?

Andy Pope

Target line to a column chart?
 
Hi,

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

Cheers
Andy

--

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



Bernard Liengme

Target line to a column chart?
 
See
http://peltiertech.com/Excel/Charts/...orzSeries.html
note the links at the bottom of this page for other methods
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Deb" wrote in message
...
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?





All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com