| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Highlight Fluctuating Breakeven Point
I have a chart that is based on user input and depending on the value the
user enters the breakeven point will fluctuate. I have manually put a text box in the graph with details about the breakeven point. I would like to automate that so when the user changes inputs the text box is updated with new information. Is this possible? -- Thank You, Steve |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Highlight Fluctuating Breakeven Point
Hi,
You need to calculate the intersection point and then plot that as another series with data label. See this example. http://www.andypope.info/charts/intersection.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steve D" wrote in message ... I have a chart that is based on user input and depending on the value the user enters the breakeven point will fluctuate. I have manually put a text box in the graph with details about the breakeven point. I would like to automate that so when the user changes inputs the text box is updated with new information. Is this possible? -- Thank You, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Breakeven graph | Excel Discussion (Misc queries) | |||
| how to highlight a cell so I know which point on the chart it is? | Charts and Charting in Excel | |||
| How to bold/highlight data point in chart | Charts and Charting in Excel | |||
| breakeven analysis chart | Charts and Charting in Excel | |||
| Breakeven Chart | Charts and Charting in Excel | |||
Linear Mode
