At this time I've used only the following two solution alternatives, one direct and one indirect. For form-like data, I'd suggest the Indirect one. If you want to include for example a name in the middle of text, the Indirect method might be feasible. At least if the surrounding text is not updated often.
Create a chart from a single cell and link it to Google Docs through
Insert Chart > From Sheets. This option requires a bit of tweaking and doesn't update automatically (in the time of writing). Try the following in Google Sheets
- Select the cell for output
Insert > Chart
- Change the
Data Range to contain only the desired cell
Use row [ ] as headers
Chart type to
Scorecard chart (down in
- from tab
Customise remove the title by giving an empty string in
Chart and axis titles > Title text
- Optionally: change the font in
Customise > Chart style
Now the chart is ready for linking in Docs. However as already mentioned, the data didn't update immediately. After a Docs refresh an
Update-button appeared over the chart. And that's why I'd recommend the following solution.
Use Sheets for formatting the text, keeping the text in one sheet and the data in one sheet (or several). Then the data from other sheets is easily linked to the the text part. Works but the text editing part is cumbersome for example in contract texts where the data is in the middle of the flow.