Excel Forum

Some issues with multi-color line chart on Youtube video

m Shi

Member

Members

Forum Posts: 21

Member Since:
January 5, 2021

Offline

January 5, 2021 - 10:29 pm

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"

Attachments

Capture.JPG (61 KB)

See Answer

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1824

Member Since:
November 8, 2013

Offline

January 7, 2021 - 1:20 am

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.

m Shi

Member

Members

Forum Posts: 21

Member Since:
January 5, 2021

Offline

January 7, 2021 - 4:57 pm

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.

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1824

Member Since:
November 8, 2013

Offline

January 7, 2021 - 5:04 pm

Which is the expected result?
please provide a sample file and an image of how you want the result to be.

m Shi

Member

Members

Forum Posts: 21

Member Since:
January 5, 2021

Offline

January 10, 2021 - 10:21 pm

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.

Attachments