Embark on a journey of data visualization innovation as we delve into the realm of using Coefficient's Chart Builder to craft dynamic charts within Google Sheets. In this knowledge article, we explore the transformative capabilities that GPT brings to the process of chart creation, offering a seamless integration that enhances efficiency and flexibility. Whether you're a data enthusiast or a spreadsheet aficionado, discover how leveraging Chart Builder can elevate your chart-building experience in Google Sheets, providing a fresh perspective on data interpretation and presentation.
*This feature is currently supported on Google Sheets only*
Using Chart Builder
🎥 Check out our Chart Builder video, here.
|
1. Open the Coefficient Sidebar and click GPT Copilot. |
2. Select "Chart Builder" from the list of options. |
|
3. Select the Range of your data, and input your prompt in the "Describe the Chart" field provided. Then click, "Build". ℹ️ NOTE: Merged cell headers may cause the Chart Builder to only recognize 1 column. Exclude the merged header and you should be good to go. |
4. Confirm where you would like the chart inserted in your sheet. You will need to select the cell for the chart to be inserted. |
4. Your chart will then populate in the cell you designated. AMAZING!
|
5. Once your chart is generated in your sheet, the sidebar will update with a "History" of the chart prompts used within that sheet. You can copy the prompt and reuse it or delete it. "Jump to cell" will take you directly to the chart's location.
ℹ️ NOTE: Provide feedback on this feature by selecting the "thumbs-up" or "thumbs-down" at the bottom of each historical prompt. Our team loves feedback. 💙 |
Chart Builder Guide
ℹ️ For more examples of how to use Chart Builder with Coefficient, click here.
FAQs for Chart Builder
Can I edit/modify the chart? How do I do that?
Yes, you can edit the chart as needed. Here are some helpful steps:
- Open the Chart Editor: Double-click your chart.
- Customize chart elements: Modify various chart elements such as titles, axis labels, data series, and legends.
- Adjust chart formatting: Change the appearance of your chart by adjusting colors, fonts, borders, and other formatting options.
- Update chart data: If you need to modify the data used in the chart, you can do so by updating the data range under Setup. Changes made to the data will automatically reflect in the chart.
ℹ️ For more information on editing charts in Google Sheets, click here.
What charts are supported?
| Basic Charts | Advanced Charts | Coming Soon! |
Not Supported (Sheets API Limitation) |
| Bar | Pie | Treemap | Gauge |
| Line | Org | Scorecard | Timeline |
| Area | Histogram | Bubble | Table |
| Column | Waterfall | Radar | |
| Scatter | Candlestick | Geo Chart | |
| Combo | |||
| Stepped Area | |||
| 100% Stacked |
Does Chart Builder support formatting specifications in the description prompt?
Currently, the Chart Builder feature doesn't allow you to include formatting details directly in the chart description. If you have specific formatting preferences, like colors, fonts, or other visual elements, you'll need to make those changes in the Chart Editor itself. We acknowledge the significance of advanced formatting options in the Chart Builder and are actively working on incorporating this feature soon. Keep an eye out for updates as we strive to improve the Chart Builder experience. Your patience and understanding are greatly appreciated!
Are there any specific keywords or phrases I need to use to describe the chart I want?
When using Chart Builder, powered by GPT, there are no specific keywords or phrases you need to use to describe the chart you want. GPT is designed to understand natural language and can interpret your description to create the chart accordingly. However, if you have a specific chart type in mind, it's helpful to explicitly mention it in your description. For example, if you want a bar chart or a line graph, make sure to call it out so that GPT can generate the chart according to your preferences. Our goal is to provide you with a flexible and intuitive experience in building charts, so feel free to describe your desired visualization using your own words.
I deleted my chart!😱😵💫 Can I undo or regenerate it from the sidebar?
Unfortunately, regenerating a deleted chart directly from the sidebar is not possible. However, there are a couple of alternatives to recover or recreate the chart. Firstly, you can explore your spreadsheet's revision history and restore an earlier version that contains the deleted chart. Alternatively, you can check your Chart Builder history, copy the original prompt used to create the chart and rebuild it by running the Chart Builder again using the copied prompt.
Can Chart Builder aggregate data for my charts?
Unfortunately, due to limitations with Google Sheet's API, Chart Builder is unable to aggregate data directly. However, if you need to aggregate your data, you can still achieve this by accessing the Chart Editor. Simply open the Chart Editor and select the option to aggregate your data on the X-axis. The Chart Editor provides additional functionality for customizing and fine-tuning your charts, including the ability to perform data aggregation. By using both the Chart Builder and Chart Editor in combination, you can create charts that suit your specific data visualization needs.
What GPT model does the Chart Builder use?
The Chart Builder uses GPT 4 Turbo, as it offers superior language processing capabilities, enabling it to generate highly accurate and contextually relevant outputs.