Hello readers and fans…
On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2021. Here is a small holiday card from Chandoo.org HQ. The kids school had a cultural festival a month ago and we got this beautiful picture at a photo booth. So much better than timer controlled DSLR on our dining table, I must say.
Thank you
2020 has been a strange year. I know many of you would have faced some form of hardship this year. So I won’t bore you with my details. Instead, let me be thankful for what it has been. Big shoutout to…
- You – my dear reader, viewer and supporter of Chandoo.org for being with me all this time and learning.
- My family – for supporting & loving me all these years
- Microsoft – for creating Excel & Power BI
- YouTube – for providing an awesome platform to share my knowledge with you
- My teachers – too many to name, but they have always guided & inspired me
- My partners – for helping my business and customers – big shout out to Plum Solutions & Global Excel Summit
- My staff – Ravindra, Pothi & Chitti for being a part of our team and running our small kingdom smoothly
- Our forum members – for lending hand to those who need help
- My customers – more than 25,000 of them. Thank you for trusting me.
- Blog friends – for sharing ideas and referring people to Chandoo.org
- Software providers – for helping me run Chandoo.org – big shout out to WordPress, Elementor, Stripe, E-Junkie, WishlistMember, KnownHost, ConvertKit, Amazon, Gmail and Techsmith
This holidays…
I feel incredibly fortunate to be living in New Zealand where covid is under control. This allows us to spend a bit of time outside our house during the holiday season. We are going a little road trip to Coromandel peninsula on the north-east side of NZ. I will share a post card from the beach when we get there by New Year.
Stay safe and see you all next year with awesome Excel & Power BI goodness. Enjoy your holidays.
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!