Image Overlay Chart

Creating Image Overlay Chart

The video shows how to create an overlay chart which is just really cool visual to create in addition to a waterfall chart

  • Use 100% Stacked Column
  • Swap Rows & Columns
  • No Fill for $ Remaining
  • Couple more edits like shrinking width, removing title, and bottom x axis, highlight $ raised/billed to red fill
  • Move image behind opaque thermometer

Comments

Post a Comment

Popular posts from this blog

Ranking of UC Schools from Top 110 Ranked National Universities of 2024

Link to GitHub:  https://github.com/sgng-hub/2024unviersityranking Link to Dataset: https://www.kaggle.com/datasets/raymondtoo/the-world-university-rankings-2016-2024 Dataset Official Source: https://www.timeshighereducation.com/world-university-rankings/2024/world-ranking This project is about writing SQL query to find the ranking of top 110 world universities that are part of the University of California System I included a link to Looker Studio visualization of the query     
Read more

Xlookup specific value in the middle of a string

EXCELIFSUN Credits goes to the YouTuber EXCELSIFUN. I was familiar with idea of using MID and XLOOKUP.  However, I liked how he pointed out by adding a zero, it can convert the text after using the MID function to a number so that we can use the xlookup. Also, if you highlight all the cells, then enter the formula in the first cell of the highlighted array, then Ctrl + Enter, you can autofill the formula throughout that whole array.
Read more

Remove Duplicates

Image
One Way to do this is to use the UNIQUE funciton, which is what I often use. For example, I have several vendor codes for different invoice number. Use the Unique function and it will remove all duplicates and give you only the unique vendor codes. This is helpful when I do entry in the accounting software, especially when there is over 500+ lines of vendor codes. Alternatively, you can use ALT + A + M to remove duplicates, so definitely will start using that more!
Read more