Want to creat custom Number formula

[william]

I want to create a custom number formula that will show the maximum value on
the value axis of my chart. I know how to make it a different color but i
havent quite figured out how to make it so that it will show a different
number instead. I want to do this without putting a text box in

 

[John Mansfield]

I would suggest creating the maximum value formula in a cell separate from
you data. Then use VBA to tie the chart to the cell with the custom formula.
Jon Peltier has an example of how to tie cells values to charts axis on his
site:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html