How to Save a Chart from Google Sheets

Creating a great-looking chart in Google Sheets is often the easy part, figuring out how to get it out of the spreadsheet and into your presentation, report, or website can be surprisingly tricky. You don’t have to resort to a clunky screenshot. This tutorial will walk you through several clear, practical methods for saving your Google Sheets charts, from high-quality images to live, interactive web versions.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Easiest Method: Download as an Image (PNG, PDF, or SVG)

The most direct way to save a single chart is using the built-in download feature. This is perfect when you need a static image file to drop into a PowerPoint presentation, a Word document, an email, or a blog post. Google Sheets gives you three different file formats to choose from, each with its own advantages.

Step-by-Step Instructions

1. Click on the chart you want to save. A faint blue line will appear around it, indicating it's selected.
2. Click the three vertical dots (the "More" menu) in the top-right corner of the chart itself.
3. Hover over "Download" and a sub-menu will appear with three options: PNG image, PDF document, and SVG (Scalable Vector Graphic).
4. Select your desired format, and the file will download directly to your computer.

That’s it! But which format should you choose? Let’s break them down.

Understanding the File Formats

• PNG Image (.png): This is your go-to format for general use. PNG files are raster images (pixel-based) that support transparency, which is great if you want to place your chart on a colored background without a white box around it. They work perfectly on the web, in slide decks (PowerPoint, Google Slides, Keynote), and for sharing in apps like Slack or Microsoft Teams. For most everyday reporting needs, PNG is the best choice.
• PDF Document (.pdf): Choose PDF when you need a high-quality version for printing or including in a formal multi-page report. PDFs are vector-based, which means you can zoom in infinitely without the chart becoming blurry or pixelated. This makes them ideal for professional documents where clarity and print quality are important.
• SVG (Scalable Vector Graphic) (.svg): SVG is the most powerful and flexible format, though it's less commonly used for simple reports. Like PDFs, SVGs are vector-based, but they are designed specifically for the web. They maintain perfect quality at any size and tend to have smaller file sizes than PNGs. If you’re a web designer or need to use a tool like Adobe Illustrator to further edit the chart's colors or text, SVG is the superior option.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Publish Your Chart to the Web for a Live, Interactive Version

What if you want to share a chart that updates automatically as you change the data in your spreadsheet? Instead of downloading and re-uploading an image over and over again, you can publish it to the web. This creates a public link to a live version of your chart that reflects any changes you make to the source data in real-time. It’s perfect for embedding in websites, company wikis, or project management dashboards.

How to Publish a Chart

1. Click on the chart you want to publish.
2. Click the three vertical dots in the top-right corner of the chart and select "Publish chart."
3. A new window will pop up with configuration options. You have a choice between "Link" or "Embed." Choose "Embed" if you want to paste a code snippet into a website (like WordPress or Notion), or choose "Link" to get a simple shareable URL.
4. By default, the chart is set to "Interactive." This means viewers can hover over data points to see specific values. If you prefer a static image, you can switch it to "Image." For most uses, interactive is better.
5. Click the "Publish" button. Google will ask you to confirm that you’re making it visible online. Click "OK."
6. Finally, copy the provided link or iframe embed code. You can now paste this into your website, blog, or wherever you want the live chart to appear.

The beauty of this method is its "set it and forget it" nature. If your chart tracks weekly sales, for example, just update the numbers in your Google Sheet each week, and the published chart displayed on your website will automatically reflect the new data without any extra steps.

The Copy-and-Paste Workflow for Google Docs & Slides

If you're working within the Google Workspace ecosystem (Docs, Slides), the integration is seamless. You can copy your chart directly from Sheets and paste it into another Google application, with a crucial option to keep it linked to the original data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Copy and Link Your Chart

1. Select your chart in Google Sheets.
2. Click the three vertical dots and choose "Copy chart" (or just use the keyboard shortcut Ctrl+C or Cmd+C).
3. Open your Google Doc or Google Slides presentation and place your cursor where you want the chart.
4. Paste the chart (Ctrl+V or Cmd+V). A small paste options box will appear.
5. You now have two brilliant choices:

Quick and Dirty: Taking a Screenshot

Let's be realistic: sometimes you just need a fast image for a quick Slack message or a casual Trello card. In these cases, a screenshot is often the fastest way to get the job done. It won’t be high-quality, and it won’t be scalable, but it will be quick.

• On Windows: Use the Snipping Tool by pressing Windows key + Shift + S. Your screen will dim, and you can drag a selection box around your chart to copy it to your clipboard.
• On Mac: Press Cmd + Shift + 4. Your cursor will turn into a crosshair. Click and drag to select the area of the screen with your chart. The screenshot will save to your desktop by default.

This method isn't for formal presentations, but it’s an indispensable part of a modern workflow for quick, informal communication.

Advanced Trick: Save a Full Dashboard to a Single PDF

What if you’ve built an entire dashboard on a single sheet with multiple charts, tables, and KPIs, and you want to save it all as one clean report? Trying to download each chart individually and piece them together is slow and clumsy. A much better way is to use the "Print to PDF" function.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Creating a PDF Dashboard

1. Arrange all your charts, tables, and text exactly how you want them to appear on your sheet. Pro tip: you can hide the gridlines by going to "View" > "Show" and unchecking "Gridlines" for a cleaner, dashboard-like look.
2. Go to the menu and select "File" > "Print" (or press Ctrl+P or Cmd+P).
3. In the print settings panel on the right, make sure the "Print" dropdown is set to "Current sheet."
4. Under "Page orientation," choose "Landscape" if your dashboard is wide.
5. Under "Scale," select "Fit to page." This will shrink your entire dashboard layout to fit neatly onto a single page.
6. Under "Formatting," you can double-check that "Show gridlines" is off and tweak other settings as needed.
7. Once you're happy with the preview, click "Next." This will open your computer’s system print dialog.
8. Instead of choosing a physical printer, find the option for "Save as PDF" and click "Save."

You now have a clean, perfectly formatted single-page PDF of your entire Google Sheets dashboard, ready to be emailed to stakeholders or clients.

Final Thoughts

Saving a chart from Google Sheets comes down to understanding your end goal. Whether you need a quick PNG for a presentation, a live interactive chart for your website, a linked visual in a Google Doc, or a full PDF report of your dashboard, there’s a straightforward method to help you get it done effectively.

While these methods are great for manually pulling visuals from your spreadsheets, we know that the real challenge is often the tedious, repetitive work of keeping everything updated and consolidating data from all your marketing and sales tools. We built Graphed to eliminate that friction. Instead of building charts and dashboards by hand, you can just connect all your data sources - like Google Sheets, Google Analytics, Shopify, and Facebook Ads - and use simple, natural language to get live, real-time dashboards that build and update themselves automatically.