| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Want to creat custom Number formula
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Want to creat custom Number formula
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/...nkToSheet.html -- John Mansfield http://cellmatrix.net "william" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to creat a formula to advance date by one year | Excel Worksheet Functions | |||
| Creat Formula for Counting Text | Excel Discussion (Misc queries) | |||
| How Do I Assign a Toolbar Button to a Custom Number Format I creat | Excel Discussion (Misc queries) | |||
| plz help in to creat formula of excel | Excel Discussion (Misc queries) | |||
| Creat a formula to calculate working hrs according to number of da | Excel Worksheet Functions | |||
Linear Mode
