ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how to add a horizontal benchmark value line in a column chart? (https://www.excelbanter.com/charts-charting-excel/149000-how-add-horizontal-benchmark-value-line-column-chart.html)

Mike Chro

how to add a horizontal benchmark value line in a column chart?
 
I need to create a vertical column chart with a horizontal benchmark line to
show where the expected value is. Is this possible in Excel?

Andy Pope

how to add a horizontal benchmark value line in a column chart?
 
Hi,

You will find examples of adding datum lines to charts here, including links
to other site examples.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mike Chro" <Mike wrote in message
...
I need to create a vertical column chart with a horizontal benchmark line
to
show where the expected value is. Is this possible in Excel?




All times are GMT +1. The time now is 06:57 PM.

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