Excel graph - intersection of 2 curves
Poucif
-
Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention -
Hello,
I have an Excel chart made up of two curves.
The first curve represents a series of data, prices. The second curve is a linear function of the first series of data.
On the x-axis, I have dates.
My goal is to know on which date to buy or sell.
I would like:
- the intersection points of these two curves to be highlighted/circled on the chart and to add a label at each intersection reading "Buy" or "Sell".
Or
- Excel to output the coordinates of the intersection points so I have the dates when we need to take action.
Thank you for your help,
Best regards
I have an Excel chart made up of two curves.
The first curve represents a series of data, prices. The second curve is a linear function of the first series of data.
On the x-axis, I have dates.
My goal is to know on which date to buy or sell.
I would like:
- the intersection points of these two curves to be highlighted/circled on the chart and to add a label at each intersection reading "Buy" or "Sell".
Or
- Excel to output the coordinates of the intersection points so I have the dates when we need to take action.
Thank you for your help,
Best regards
4 réponses
Once again...
You didn't specify which linear function it was.
I should point out that if it's a trendline, you don't need to put the data in the table; you only enter the prices, and you'll get one curve; then you ask Excel to draw a trendline using its analysis tool.
By going into the trendline format, you can check "Set intercept" and "Display equation on chart."
Moreover, if the default linear regression type doesn't suit you, you have several other types available: exponential, logarithmic, polynomial...
You could also look into the functions FORECAST, TREND, GROWTH, and LINEST in particular.
Retirement is nice! Especially in the Caribbean... :-)
? Raymond?
You didn't specify which linear function it was.
I should point out that if it's a trendline, you don't need to put the data in the table; you only enter the prices, and you'll get one curve; then you ask Excel to draw a trendline using its analysis tool.
By going into the trendline format, you can check "Set intercept" and "Display equation on chart."
Moreover, if the default linear regression type doesn't suit you, you have several other types available: exponential, logarithmic, polynomial...
You could also look into the functions FORECAST, TREND, GROWTH, and LINEST in particular.
Retirement is nice! Especially in the Caribbean... :-)
? Raymond?
Raymond PENTIER
Posted messages
58550
Registration date
Status
Contributeur
Last intervention
17 475
https://www.cjoint.com/?fwsnxQTZQy
Hello Poucif.
"I would like the intersection points of these two curves to be circled on the graph and to add a label to each intersection".
IMPOSSIBLE. The graph represents in 2 dimensions the data pairs from a table; it cannot in any way compare the pixel coordinates of the drawn curves.
"I would like Excel to output the coordinates of the intersection points so that I can know the dates when we need to act".
INDIRECTLY. You need to adjust the x-axis scale to impose a 1-day interval (text alignment/orientation vertical). You also need to display the vertical grid. It then becomes easier to identify on the graph, within half a day, when an intersection occurred.
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
"I would like the intersection points of these two curves to be circled on the graph and to add a label to each intersection".
IMPOSSIBLE. The graph represents in 2 dimensions the data pairs from a table; it cannot in any way compare the pixel coordinates of the drawn curves.
"I would like Excel to output the coordinates of the intersection points so that I can know the dates when we need to act".
INDIRECTLY. You need to adjust the x-axis scale to impose a 1-day interval (text alignment/orientation vertical). You also need to display the vertical grid. It then becomes easier to identify on the graph, within half a day, when an intersection occurred.
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂