Lakshmi Srinivas
New Member
How to give color where two series intersect each other in a scatter with smooth lines chart?
How to give color to certain part of chart ?
- Thread starter Lakshmi Srinivas
- Start date
Lakshmi
Firstly, Welcome to the Chandoo.org Forums
This may be simple or may not be simple depending on your data
If your series cross each other at a data point you could setup another series that finds where the two series intersect and plot that.
If the two series don't cross at a data point you will need to derive formulas or trendlines for each series and then calculate where they intersect. once again using a new series to plot a point.
Can you post a sample file of your data/model?
Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
Firstly, Welcome to the Chandoo.org Forums
This may be simple or may not be simple depending on your data
If your series cross each other at a data point you could setup another series that finds where the two series intersect and plot that.
If the two series don't cross at a data point you will need to derive formulas or trendlines for each series and then calculate where they intersect. once again using a new series to plot a point.
Can you post a sample file of your data/model?
Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
