Photographic Fridays #6 – Where do you want to go today?

Share

Facebook
Twitter
LinkedIn

Your only options

Yesterday evening I have suddenly realized that I don’t have any photos to post for today edition of Photographic Fridays, I didn’t want this category to be a still born like the erstwhile Calvin fund 😀 So I took out the D40 and marched out of house in search a subject worth my clickitch.

While walking outside the apartment complex spotted this ominous looking traffic sign and I instantly knew what sepia tone could do to this. So there you go.

Now tell me, where do you want to go today? Left, Right or Straight ?

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

9 Responses to “Show forecast values in a different color with this simple trick [charting]”

  1. Jake says:

    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.

    • Andy F says:

      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.

  2. Simply and clever 🙂

  3. Kiev says:

    Quick & effective, cool. thanks.

  4. dan l says:

    I always use the dummy series.

  5. Peter Stratton says:

    Nice little trick, thanks very much!

  6. excel says:

    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.

  7. gossip_boi says:

    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???

  8. Great tutorial. Thanks for the tutorial!

Leave a Reply