Overview
Extract existing chart configurations from your Google Sheets and render them beautifully with Chartcastr’s advanced charting engine. Your data stays private and secure.Recommended — This is the best option for most use cases. Reuses your existing chart configurations while keeping data private.
How It Works
- Connect your Google account to Chartcastr
- Select a spreadsheet from your Google Drive
- Choose an existing chart from the spreadsheet
- Chartcastr automatically:
- Extracts the chart configuration (type, colors, axes, series, etc.)
- Pulls the data from the specified ranges
- Renders a beautiful chart using Recharts
- Save as a source and connect to your destinations
Features
- ✅ Private Data: Keep your spreadsheets private — no need to publish publicly
- ✅ Full Configuration: Preserves chart type, colors, axis titles, legends, and stacking
- ✅ Multiple Chart Types: Supports bar, line, area, pie, and scatter charts
- ✅ Live Preview: See exactly how your chart will look before saving
- ✅ OAuth Authentication: Secure access using your Google account
- ✅ Auto-sync: Data, ranges, grouping, and styling update automatically when your spreadsheet changes
Automatic Reflection of Changes
One of the key benefits of using Premade Charts is that Chartcastr automatically registers changes made within your spreadsheet. If you perform any of the following in Google Sheets:- Update Data: Add new rows or change existing values
- Adjust Ranges: Expand or shrink the data ranges assigned to the chart
- Change Grouping: Modify how data is aggregated or categorized
- Formatting: Update chart titles, legend positions, or series colors
Supported Chart Types
Chartcastr supports the following Google Sheets chart types:| Google Sheets Type | Rendered As | Notes |
|---|---|---|
| Column Chart | Bar Chart | Vertical bars |
| Bar Chart | Bar Chart | Horizontal bars |
| Line Chart | Line Chart | Standard lines |
| Area Chart | Area Chart | Filled areas |
| Stepped Area Chart | Area Chart | Unified with area |
| Scatter Chart | Scatter | Scatter plot |
| Pie Chart | Pie Chart | Pie/donut charts |
| Combo Chart | Line Chart | Defaults to line |
Unsupported Chart Types
The following are detected but not currently supported:- Candlestick, Histogram, Bubble, Waterfall
- Treemap, Org Chart, Scorecard
- Geographic/region charts
Let us know if you’d like to see a specific chart type supported.
Setup Steps
Create a chart in Google Sheets
If you haven’t already, create the chart you want to share in your spreadsheet.
Add source in Chartcastr
Go to Sources → New Source → Google Sheets and search for your spreadsheet.
Published Chart URLs (Alternative)
If you prefer, you can also use a published chart URL. This requires making the chart publicly accessible.Using Published Chart URLs
Using Published Chart URLs
- Open your Google Sheet and select the chart
- Click the three-dot menu → Publish chart
- Set to Image format and Anyone on the internet can view
- Copy the URL and paste into Chartcastr
Example URL