Chart Wizard Pro - Google Charts in Google Sheets
Chart Wizard Pro: Instant Visualization Sidebar for Google Sheets
Tired of spending precious time setting up charts, formatting data, and endlessly tweaking settings in Google Sheets? Wish you could instantly visualize your data or prototype different chart types without the usual hassle?
Chart Wizard Pro is your new secret weapon! This powerful Google Sheets Add-on puts a chart creation studio right into your sidebar. Simply select a chart type, and instantly get a new sheet tab populated with perfectly structured dummy data and helpful comments, ready for your input.
See Your Data Come Alive - Instantly!
The core of Chart Wizard Pro is the interactive Live Sidebar Preview. See your chart rendered beautifully directly in the sidebar using Google Charts technology, based on the data in the generated sheet tab. Edit your data, click "Refresh Chart Data" in the sidebar, and watch your visualization update!
Key Features & Benefits:
- INSTANT CHART & DATA SETUP: Choose from a growing list of chart types. Chart Wizard Pro instantly creates a dedicated sheet tab with ready-to-use dummy data formatted specifically for that chart, complete with comments guiding you on data entry.
- LIVE SIDEBAR PREVIEW: Visualize your data immediately within the sidebar as you work. No need to embed charts into your sheet just to see how they look.
- EASY DATA UPDATES: Simply edit the data in the generated sheet tab. Click the "Refresh Chart Data" button in the sidebar, and the preview chart updates instantly to reflect your changes.
- SIMPLE PREVIEW CUSTOMIZATION: Quickly change titles and background colors for your sidebar chart preview using intuitive controls. Perfect for tweaking the look before export. (Note: Controls affect sidebar preview/exports only).
-
FLEXIBLE EXPORT OPTIONS:
- Download PNG: Download your customized sidebar chart preview as a high-quality PNG image, ready for presentations or reports.
- Insert Image to Sheet: Add a static image of the current chart preview directly into your active Google Sheet with a single click.
- SAVE HOURS WEEKLY: Drastically reduce the time spent on repetitive chart setup, data structuring, and manual formatting. Focus on insights, not setup.
- EXPLORE VISUALIZATIONS EFFORTLESSLY: Easily generate multiple chart types from the same base data concept to quickly compare and find the most effective way to tell your data's story.
- PERFECT FOR PROTOTYPING & REPORTS: Quickly mock up dashboard elements, generate charts for presentations, or create visual aids for reports without disrupting your main data sheets.
Included Chart Types (v0.1.x):
- Pie Chart
- 3D Pie Chart
- Donut Chart
- Bar Chart (Horizontal)
- Stacked Bar Chart
- Column Chart (Vertical)
- Stacked Column Chart
- Candlestick Chart
- Area Chart
- Stacked Area Chart
- Scatter Plot
- Sankey Diagram (More chart types planned for future updates!)
How It Works - Simple Setup:
- Purchase: Click "Buy this" to get your unique lifetime license key and the add-on script files.
-
Install: Open your target Google Sheet. Go to
Extensions > Apps Script
. Copy the code from the providedCode.gs
andSidebarCharts.html
files into corresponding files in your script editor. Click Save. - Open & Activate: Refresh your Google Sheet. A new "Chart Creator" menu will appear. Click it, then "Open Chart Creator". When the sidebar opens, enter your license key when prompted to activate the tool for this specific document. (You'll only need to do this once per sheet).
- Select & Create: Choose a chart type from the dropdown in the sidebar and click "Create".
- Add Your Data: Go to the newly created sheet tab (e.g., "ChartData_PieChart_1") and replace the dummy data with your own, following the structure and comments.
- Refresh & Customize: Click "Refresh Chart Data" in the sidebar to update the preview. Use the controls below the chart to customize the preview's title and background color.
- Export: Click "Download PNG" or "Insert Image to Sheet" as needed!
License Details:
- One-Time Purchase = Lifetime Access! Your purchase includes the current version and all future updates. No recurring fees.
- Document-Based Activation: Your key activates Chart Wizard Pro for the specific Google Sheet document where you enter it. Anyone you share that sheet with (who has edit access) can also use the activated tool within that sheet. You can use your single key to activate the tool in multiple different Google Sheet documents that you own or edit.
What You Get:
- The
Code.gs
file containing the core Google Apps Script logic. - The
SidebarCharts.html
file containing the sidebar user interface and client-side JavaScript (including Google Charts integration). - Clear instructions on how to install and activate the script.
Stop Guessing, Start Visualizing!
Unlock powerful, instant charting capabilities within Google Sheets. Get Chart Wizard Pro today and transform your data visualization workflow.
Click "Buy this" now to get your license key!
For a full feature list, visual examples, and FAQs, please visit our main product page: https://macondolabs.com/[your-chart-wizard-page-url]
(<-- Replace with the actual URL on your site)