Hiya folks… Got an exciting news to share with you all. Over the weekend, my YouTube channel hit 50,000 subscriber milestone.
Thank you so much for making me a part of your journey to awesomeness.
I want to celebrate this occasion with 3 things:
- Special message from cute guests
- 5x Amazon gift card give away
- 5x Excel tricks
Check out all the details in below video (or watch it on my YouTube channel)
50k subs – give away contest rules
To participate, you must do all three things listed below:
- Subscribe to my YouTube channel (here)
- Like any of the videos on my channel
- Leave a comment on the give away video (here)
Important dates:
- Contest opens – today (25th of May 2020)
- Contest closes – Monday, 1 June 2020 – end of day, Pacific time
Thank you
Thank you so much once again for being a part of Chandoo.org community. You motivate and inspire me to learn and share. Thank you.
9 Responses to “Show forecast values in a different color with this simple trick [charting]”
While this works in a pinch, it clearly "lightens" the colors of the entire chart. Depending on where you use this, it will be blatantly obvious that you don't know what you are doing and present a poor looking graph.
Why not separate the data into different segments when charting and have as many colors as you have data points? You might have to create a new legend and/or repeat the chart in "invisible ink", but it would be cleaner and more consistent when new or updated data becomes available.
While I think I agree that doing it "properly" via a second series is preferable, I don't necessarily agree that making the entirety of the "future" (data, gridlines, and even the axis) semi-transparent is "poor looking". I think it could be seen as adding more emphasis to the "future-ness" of the forecast data.
In short, it's another tool for the toolbox, even if it's never needed.
Simply and clever 🙂
Quick & effective, cool. thanks.
I always use the dummy series.
Nice little trick, thanks very much!
Two sets of data better. Control is much better.
You can use the same chart next month to see what is actual and what is forecast.
To use this trick, I think grid lines has to be removed, that will make the graphic much more sharp.
to be honest, i dont understand why there is needed to do this way... in this case horizontal lines will be pale as well. then why a just can't change the color of the line partly???
Great tutorial. Thanks for the tutorial!