I tried to make a simple line chart with multi-color. If the data of current month is higher than previous month, highlighted in red, otherwises highlighted in green. Unfortunately, I got some partial line are not showed as expected. Please see attached picture. The line between "May to Jun" not hightlight in red as expected. also as "August to Sep"
Hi,
May and August have N/A values, the red lines cannot start from these values.
You will have to adjust those formulas to start showing the line as you want.
Thanks. I used the way as "Multi-colored Excel Line Charts" on Youtube and I used similar formula. Could you please let me know detail steps how to correct this? Currently I tried to manually operate data to get expected result.
Which is the expected result?
please provide a sample file and an image of how you want the result to be.
Please see picture expected attached. You can notice I manipulate data in column U for couple cells. I want to have an auto way similar like the Youtube video showed with accepted result. Tahnks in advance.
You can use this formula assuming your values start in row 2 of column T;
=IF(OR(T2>T1,T3>T2),T2,NA())
Note: you should avoid using the smoothed line effect for this type of chart.
Mynda
Thanks a lot. It works now.