From the course: Excel and ChatGPT: Data Analysis Power Tips

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Ask for Excel data visualization advice

Ask for Excel data visualization advice

From the course: Excel and ChatGPT: Data Analysis Power Tips

Start my 1-month free trial Buy for my team

Ask for Excel data visualization advice

“

- [Instructor] All right, so for our next demo, I'd like to explore how we might be able to use tools like ChatGPT for data visualization. Now, even though ChatGPT can't currently produce visual responses outside of code samples, at least not yet, I'm curious if we can use it to better understand data viz best practices, or have it recommend effective visuals based on some given context. So let's go ahead and drop in a few prompts, and kind of grade or score the responses we get back. So first prompt, I'm analyzing a sample of wine data and would like to understand the distribution of wines by price point. What will be the best way to visualize this in Excel? Now I'm being very deliberate about how I've written this prompt, specifically the use of this term distribution, right? Because anyone who has expertise in data visualization should recognize that histograms are widely known as the clearest and most effective way to…

Contents