Log In
Register
Home
January 5, 2021
Offline
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"
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Offline
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.
January 5, 2021
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Offline
Which is the expected result?
please provide a sample file and an image of how you want the result to be.
January 5, 2021
Offline
1 Guest(s)
