---
title: "Using ChatGPT for data visualization"
slug: "using-chatgpt-for-data-visualization"
date: "2024-11-13"
updated: "2024-11-13"
status: "published"
featured: false
access: "pro"
difficulty: "beginner"
one_liner: "Interact with, customize and download charts using ChatGPT’s expanded view."
tools: ["ChatGPT"]
topics: ["Data & Reporting"]
roles: ["Data Analyst"]
categories: ["Creatives and Multimedia"]
---

<!-- migrated_from_webflow_csv -->

<!-- UNRESTRICTED -->

<div class="unrestricted">

<p id="">ChatGPT is incredibly powerful, even if you’re not using its most advanced features. From generating code to answering questions, there’s a reason it’s one of the fastest-growing consumer apps of all time.</p><p id="">However, you can unlock even more utility with some of ChatGPT’s newest, advanced features. In this tutorial, we’ll cover connecting 3rd party apps (e.g. Google Drive) to ChatGPT and using advanced analytics to interact and customize data with charts.</p><p id=""><strong id="">You’ll need:</strong></p><ul id=""><li id="">ChatGPT</li></ul><p id=""><strong id="">Steps:</strong></p><ul id=""><li id="">Connect 3rd party data sources to ChatGPT</li><li id="">Interact with charts in a new expandable view</li><li id="">Customize and download charts for presentations and documents</li></ul>

</div>

<!-- RESTRICTED -->

<div class="restricted" data-access="pro">

<h4 id="">Connect 3rd party data sources to ChatGPT</h4><p id="">If you use a cloud-based document manager, like Google Drive or Microsoft OneDrive, then chatting with those documents in ChatGPT has gotten much easier. Now when you click the attachment button to upload a file, you can choose to select a document from either Google Drive or Microsoft OneDrive.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="2132px" data-rt-type="image" style="max-width:2132px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d0d_Untitled_-_2024-06-21T093120.682.webp"/></div></figure><div data-rt-embed-type="true"><div style="padding: 20px; margin: 10px 0; background-color: #ffe8ed; border-left: 5px solid #f78ae0;"><strong>💡 Tip:</strong> This integration isn’t an indexing of ALL of your documents in Google Drive or Microsoft OneDrive, but allows for a faster uploading experience by providing ChatGPT access to a document from your cloud document manager without having to download and upload the file.</div></div><p id="">We’ll go with connecting our Google Drive to ChatGPT. To do this, click on the “Connect to Google Drive” button on the attachment pop-up. If you haven’t authenticated the connection, you’ll be prompted to authenticate the application. Go through that process and you’ll be navigated back to ChatGPT with an open Google Drive modal.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="3298px" data-rt-type="image" style="max-width:3298px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919cf9_Untitled_-_2024-06-21T093134.033.webp"/></div></figure><div data-rt-embed-type="true"><div style="padding: 20px; margin: 10px 0; background-color: #ffe8ed; border-left: 5px solid #f78ae0;"><strong>💡 Tip:</strong> Sometimes the Google Drive modal can have an error message. If this occurs, refresh the screen and your drive folders should appear.</div></div><p id="">We’ll search for a file called “Fake Data” within our Google Drive. You can either search for documents using the search bar or click through folders in the visual window.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="3292px" data-rt-type="image" style="max-width:3292px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919cfe_Untitled_-_2024-06-21T093136.258.webp"/></div></figure><p id="">With our document selected, we can have ChatGPT summarize the data to make sure it has access and we have the right document loaded for analysis.</p><p id=""><strong id="">Sample prompt:</strong></p><blockquote id="">Summarize the attached data.</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1844px" data-rt-type="image" style="max-width:1844px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d14_Untitled_-_2024-06-21T093204.392.webp"/></div></figure><h4 id="">Interact with charts in a new expandable view</h4><p id="">Now that we have our data loaded from Google Drive, we can start generating interactive charts within ChatGPT using the new analytics engine. We’ll start by having it create a trend chart from our data.</p><p id=""><strong id="">Sample prompt:</strong></p><blockquote id="">Can you create a [insert chart type] from the attached data?</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1674px" data-rt-type="image" style="max-width:1674px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d10_Untitled_-_2024-06-21T093207.222.webp"/></div></figure><p id="">Click the expand button in the top right corner of the chart to expand the graph into a full-screen view. This is where we can start chatting with ChatGPT about the specific graph to edit specific components.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1650px" data-rt-type="image" style="max-width:1650px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d01_Untitled_-_2024-06-21T093209.661.webp"/></div></figure><p id="">To start, we’ll remove the Sales trend line that was created in the graph by asking ChatGPT to remove it.</p><p id=""><strong id="">Sample prompt:</strong></p><blockquote id="">Can you remove the [insert variable]?</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1989px" data-rt-type="image" id="" style="max-width:1989px"><div id=""><img alt="__wf_reserved_inherit" height="auto" id="" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d04_Untitled_-_2024-06-21T093250.188.webp" width="auto"/></div></figure><p id="">We can also update the graph axes by telling ChatGPT to group the data differently. In this example, we’ll ask ChatGPT to group the data by month.</p><p id=""><strong id="">Sample prompt:</strong></p><blockquote id="">Can you group the data by [insert variable] in the chart?</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="3828px" data-rt-type="image" style="max-width:3828px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d18_6-21T093354.084.webp"/></div></figure><div data-rt-embed-type="true"><div style="padding: 20px; margin: 10px 0; background-color: #ffe8ed; border-left: 5px solid #f78ae0;"><strong>💡 Tip:</strong> You need to switch the chart to “Static Mode” using the setting in the top right corner to see updates made to axes. In the interactive chart, you will always see the same default data, but in the “Static Mode,” you will see your requested changes. This is the visual that will download as well, so you can think of this as a preview pane.</div></div><h4 id="">Customize and download charts for presentations and documents</h4><p id="">Now that we have our data structured in the way we like, we can update the colors on the chart. To do this, click on the Settings button in the top right corner, hover over the colored item you want to update (in this case our Revenue line), and select a new color either from the provided swatches or via hex code. We’ll change our trend line to red in this example.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="3834px" data-rt-type="image" style="max-width:3834px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d1b_6-21T093423.279.webp"/></div></figure><p id="">Once you’re happy with the appearance, you can download the chart with the download button in the top right corner.</p><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="2970px" data-rt-type="image" style="max-width:2970px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d23_6-21T093430.510.webp"/></div></figure><div data-rt-embed-type="true"><div style="padding: 20px; margin: 10px 0; background-color: #ffe8ed; border-left: 5px solid #f78ae0;"><strong>💡 Tip:</strong> The downloaded chart will be in PNG format and will match the look of the “Static Mode” version, not the Interactive Version, as previously mentioned.</div></div><p id="">Lastly, you can experiment with other chart and graph visuals. To do this, collapse the expanded view and ask ChatGPT to generate new visuals by the specific graph type. To start, we’ll generate a bar chart.</p><blockquote id="">Can you generate a [insert chart type] for this data?</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1638px" data-rt-type="image" style="max-width:1638px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d0a_Untitled_-_2024-06-21T093503.665.webp"/></div></figure><p id="">Finally, you can request ChatGPT to generate a chart by specific groupings by adding them to your prompt. In this example, we’ll generate a pie chart by sales per region.</p><blockquote id="">Can you generate a [insert chart type] for this data by [insert variable] per [insert variable]?</blockquote><figure class="w-richtext-figure-type-image w-richtext-align-fullwidth" data-rt-align="fullwidth" data-rt-max-width="1722px" data-rt-type="image" style="max-width:1722px"><div><img alt="__wf_reserved_inherit" loading="lazy" src="https://cdn.prod.website-files.com/66eeba0c7a01b10910c883da/67263ddae3a0d4a2d6919d07_Untitled_-_2024-06-21T093511.878.webp"/></div></figure><div data-rt-embed-type="true"><div style="padding: 20px; margin: 10px 0; background-color: #ffe8ed; border-left: 5px solid #f78ae0;"><strong>💡 Tip:</strong> You do not need to go into the expanded view to perform some of the visual adjustments to your charts and graphs. You can update to static mode, change chart colors, and download the chart in the non-expanded view of your charts as well by clicking on the icons in the top right corner.</div></div><p id="">And that’s it! If you’ve made it this far, you’re a ChatGPT data visualization pro. We find it’s a great tool for experimenting with data visualizations to eventually drop into presentations or use as a pre-production step in your data analytics process.</p><p>This tutorial was created by <a href="https://garretthoughton.com/" id="">Garrett</a>.</p>

</div>
