Hi Cole, thanks for the (Storytelling with data). I found it very helpful, helping me improve my thesis charts. its was look awful and I thought it was great. after reading your book I tried to make all charts again and pay attention to your tips. now it's more authentic, maybe still not excellent but at least very good.
Hi John, thanks for watching! Yes, we can definitely add slopegraphs to our list of future topics. In the meantime, you can read about and see examples in the SWD chart guide: www.storytellingwithdata.com/blog/2020/7/27/what-is-a-slopegraph
Yes, you can animate data within a single slide using PowerPoint's built-in chart animation features. Check out our tutorial to learn more: th-cam.com/video/-Ple4ZfrFlM/w-d-xo.html Regarding your question about how to color three bars at once, this works well when you plan to share the slide instead of presenting it. I'd suggest using two distinct colors and adding annotations for context in that scenario. For example, use dark blue bars for macadamia nuts and coconut (preferred ingredients) and orange for hazelnuts (disliked ingredients). There is no right or wrong way to use color; it's all about being intentional and thoughtful. Hope this helps!
Hi Cole! Love your videos. How do you typically implement the contrast difference in a slide? If I have a static graph output from some R or Python code, I could envision a few solutions: 1. Reproduce the graphs in the code multiple times, each time highlighting the bar(s) I want to focus on, and put each different graph on its own slide / animation pane 2. Use the same static graph image, but use some kind of shaded rectangle(s) in Powerpoint to cover different bars to achieve the desired highlighting 3. Build the bar graphs entirely in Powerpoint and manually change the rectangle colors in the different slides to achieve the highlighting you want in order (seems tedious and is very difficult/impossible with more complicated graphs) Do you have thoughts on which of these approaches works best? Thanks!
Hi Thomas, Cole here. I'm happy to hear you like the videos! Yes, any of the three approaches you outline will work to emphasize different aspects of a graph. I used to follow the first one you outline, where I'd build separate graphs in Excel, each drawing attention through sparing contrast to a given data point or part of the graph. Then I'd copy and paste each of those into PPT on subsequent slides. The second approach you outline can be a brute force option when you are constrained for time, or if you need to use a screenshot or provided visual (where you can't easily modify the graph directly). In the example in the video, I followed the third approach you outlined. I built the graph directly in PPT, then repeated it on separate slides, modifying each to draw attention to the given point. I find this to be most efficient for how I currently present. That said, one drawback to this approach is that if the data changes, you have to change it in the spreadsheet behind EACH of the various graphs (whereas with option 1, you can change the data once because all the graphs you've made or code you've written point to the same source data). I hope this helps. Which will work best likely depends on your specific situation, so take that into account. Thanks for following!
Just started reading your book, Story Telling With Data. Will be back to share my learning and understanding.
Hi Cole, thanks for the (Storytelling with data). I found it very helpful, helping me improve my thesis charts. its was look awful and I thought it was great. after reading your book I tried to make all charts again and pay attention to your tips. now it's more authentic, maybe still not excellent but at least very good.
Hi guys! I was wondering if u could make a video on slope charts and use cases. Btw, this was cool
Hi John, thanks for watching! Yes, we can definitely add slopegraphs to our list of future topics. In the meantime, you can read about and see examples in the SWD chart guide: www.storytellingwithdata.com/blog/2020/7/27/what-is-a-slopegraph
@@storytellingwithdata thanks
I wonder how we could do this in a single slide. Which coloring method would you use if you were to highlight 3 bars at the same time?
Yes, you can animate data within a single slide using PowerPoint's built-in chart animation features. Check out our tutorial to learn more: th-cam.com/video/-Ple4ZfrFlM/w-d-xo.html
Regarding your question about how to color three bars at once, this works well when you plan to share the slide instead of presenting it. I'd suggest using two distinct colors and adding annotations for context in that scenario. For example, use dark blue bars for macadamia nuts and coconut (preferred ingredients) and orange for hazelnuts (disliked ingredients). There is no right or wrong way to use color; it's all about being intentional and thoughtful. Hope this helps!
Hi Cole! Love your videos. How do you typically implement the contrast difference in a slide? If I have a static graph output from some R or Python code, I could envision a few solutions:
1. Reproduce the graphs in the code multiple times, each time highlighting the bar(s) I want to focus on, and put each different graph on its own slide / animation pane
2. Use the same static graph image, but use some kind of shaded rectangle(s) in Powerpoint to cover different bars to achieve the desired highlighting
3. Build the bar graphs entirely in Powerpoint and manually change the rectangle colors in the different slides to achieve the highlighting you want in order (seems tedious and is very difficult/impossible with more complicated graphs)
Do you have thoughts on which of these approaches works best? Thanks!
Hi Thomas, Cole here. I'm happy to hear you like the videos! Yes, any of the three approaches you outline will work to emphasize different aspects of a graph. I used to follow the first one you outline, where I'd build separate graphs in Excel, each drawing attention through sparing contrast to a given data point or part of the graph. Then I'd copy and paste each of those into PPT on subsequent slides. The second approach you outline can be a brute force option when you are constrained for time, or if you need to use a screenshot or provided visual (where you can't easily modify the graph directly).
In the example in the video, I followed the third approach you outlined. I built the graph directly in PPT, then repeated it on separate slides, modifying each to draw attention to the given point. I find this to be most efficient for how I currently present. That said, one drawback to this approach is that if the data changes, you have to change it in the spreadsheet behind EACH of the various graphs (whereas with option 1, you can change the data once because all the graphs you've made or code you've written point to the same source data).
I hope this helps. Which will work best likely depends on your specific situation, so take that into account.
Thanks for following!
@@storytellingwithdata Thank you so much for the response! This is helpful. :)
Nice