Multi-colored Excel Line Charts - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 5
varghsan
Dear Mynda, I need a line chart with color variation as mentioned below:
Green under 69%-
Yellow from 70 to 79%-
Orange from 80 to 89%-
Red from 90 to 100%-
I guess the columns would be 90+ Red, 80+ Orange, 70+ Yellow and 70- Green.
Can you help me with creating the formulas for the above columns ?
reply
Dear Mynda, I need a line chart with color variation as mentioned below:
Green under 69%-
Yellow from 70 to 79%-
Orange from 80 to 89%-
Red from 90 to 100%-
I guess the columns would be 90+ Red, 80+ Orange, 70+ Yellow and 70- Green.
Can you help me with creating the formulas for the above columns ?
reply
Wayne
HI Mynda.. thanks for the video and some good tricks for making multi-colored line charts. Admittedly, they are a bit of a gimmick. But at times, they can be just the thing to get some attention where wanted or needed. Thanks for sharing. Thumbs up for MyOnlineTrainingHub!
reply
HI Mynda.. thanks for the video and some good tricks for making multi-colored line charts. Admittedly, they are a bit of a gimmick. But at times, they can be just the thing to get some attention where wanted or needed. Thanks for sharing. Thumbs up for MyOnlineTrainingHub!
reply
itech
I tried to use the 2nd way to color for 12 months day, if data of month is increase compared with previous month, highlighted to red, otherwise to green. But it didn't work perfectly. Some parts didn't change color. Could you please double check?
reply
I tried to use the 2nd way to color for 12 months day, if data of month is increase compared with previous month, highlighted to red, otherwise to green. But it didn't work perfectly. Some parts didn't change color. Could you please double check?
reply
itech
Hi Mynda, excellent video! Liked and sub! Wonder would it be possible to color the area below the line all the way to zero with the same color represented by your colored lines?
reply
Hi Mynda, excellent video! Liked and sub! Wonder would it be possible to color the area below the line all the way to zero with the same color represented by your colored lines?
reply
Avi
What happens if we need to replicate this style on a pivot table? Is it possible to create a dax measure and then get these color differences
reply
What happens if we need to replicate this style on a pivot table? Is it possible to create a dax measure and then get these color differences
reply
Add a review, comment
Other channel videos
11:15
5:53
