Hello readers & fans,
On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2022. Here is a small holiday card from Chandoo.org HQ.
About this year’s card: (From left: Nishanth, Jo, Nakshu & Chandoo) We went to the beautiful Queenstown this October to celebrate my 40th (XL Birthday!!!) and took this picture just before a sunset. The kids are now taller than mum and as tall as me. We will be taking family pictures sitting down from now on, so that they don’t look like giants. ?
Thank you
2021 has been a very positive and inspiring year for me. I found a renewed sense of mission to learn, grow & share with the world. Even though I did not blog much this year, I have been very active on YouTube, building a community of Excel / Power BI learners. I want to take a minute to acknowledge some of the people & organizations that helped me this year.
- You – for reading my articles, watching the videos or learning from a course. Thank you for making me your learning partner.
- My family – for supporting & loving me all this while. My kids & Jo also played an important role in filming or giving feedback on my videos.
- Microsoft – for creating Excel & Power BI.
- YouTube – for providing an awesome platform to learn & share
- My teachers – too many to name, but thanks for guiding and inspiring me. Some quick shout outs
- YouTube & Video related: Dusty Porter, Tim & team at Video Creators
- Life & Inspiration: Wheezy Waiter, Ali Abdaal, Simone Giertz, ElectroBoom
- Conference & events: This year I had the fortune of presenting virtually at many meetups and events. Special thanks to Vena Corp & Global Excel Summit.
- My staff – Ravindra & Pothi for keeping the gears turning and helping me focus.
- My customers – thanks to more than 1,200 people who bought a course, template, e-book or live cohort membership this year and supported me.
- My Supporters – Thanks for more than 145 people who donated a superchat / supersticker during my YouTube live streams this year.
- Our forum regulars & mods – thanks for taking time to help and share your knowledge.
- Blog & channel friends – for recommending & sending people my way. Big thanks to Bill Jelen, Danielle, Ken Puls, Alan Murray, Sumit Bansal & Boriana for sharing a few tips on the channel
- Software providers – for helping me run the site & channel. Big thanks to WordPress, Elementor, Stripe, E-junkie, PayPal, Wishlistmember, KnownHost, ConvertKit, Amazon, Gmail, Techsmith, EpidemicSound, Unsplash, Pexels & Pixabay
This holidays…
We (Jo & I) are taking some time off the work and traveling with kids to South Island on a road trip. We will be visiting Christchurch & Kaikoura for 10 days. I will be sipping beer on the beaches or going for a swim between now & 4th of Jan.
Once again, I wish you a very happy Christmas & a prosperous New Year 2022.
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!