ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Trace a costant value on Graph (https://www.excelbanter.com/charts-charting-excel/25801-trace-costant-value-graph.html)

Fabiez

Trace a costant value on Graph
 
I want to trace a costant value on graph.
How I can set this ?
If I put this "={2}" on value field a trace a point on graph,
there is a function that trace a line ?

Thank in advance.




Andy Pope

Hi,

Here are some examples of how to add a datum line to your chart.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Fabiez wrote:
I want to trace a costant value on graph.
How I can set this ?
If I put this "={2}" on value field a trace a point on graph,
there is a function that trace a line ?

Thank in advance.




--

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


All times are GMT +1. The time now is 09:16 AM.

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