sparkline

81 views
Skip to first unread message

Sam Eslamieh

unread,
Nov 7, 2023, 2:11:05 AM11/7/23
to NV Autocrat Add-on
Hi,
I'd like to use autocrat to print sparklines. Has anybody had any success with this?
Thanks

Joseph Schmidt

unread,
Nov 9, 2023, 10:27:46 AM11/9/23
to nv-autocr...@googlegroups.com
The only way I think you will get this to work is if you can locate an online service that will provide a chart based on data passed to it.

I have seen a QR code included as an image using a URL including the data which returned the image.  I would think the same thing would work if you can locate such a tool for charts.

I tried but was unsuccessful.  That doesn't mean there isn't a tool.  Just that I had to move on to other things.



--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/1e5c16d6-171b-462f-900e-b92770bb78d2n%40googlegroups.com.

Joseph Schmidt

unread,
Nov 9, 2023, 5:58:05 PM11/9/23
to nv-autocr...@googlegroups.com
On further thought, I would think you can do it if you use a spreadsheet as the template.

You could pull in the data needed and let a formula in the template create the sparkline.

If you could share a sample of the data and desired output, that would be great.
On Tue, Nov 7, 2023 at 2:11 AM Sam Eslamieh <sesl...@brent.edu.ph> wrote:
--

Sam Eslamieh

unread,
Nov 10, 2023, 6:52:58 AM11/10/23
to NV Autocrat Add-on
here you go https://docs.google.com/spreadsheets/d/1wgbMhSiY1A5yOjq9BFuML6e8Cm7j_cU3Uh9R59_cOfE/edit#gid=1674200758

The output is just some basic information which I can easily pass to autocrat except for the sparkline image.

Joseph Schmidt

unread,
Nov 12, 2023, 2:12:53 AM11/12/23
to nv-autocr...@googlegroups.com
I had some time so I experimented.  See folder.  The first thing you will notice is I'm not a sparkling or chart maker.

The data is merged to a hidden sheet which is used to create the sparkling and chart.  
On Tue, Nov 7, 2023 at 2:11 AM Sam Eslamieh <sesl...@brent.edu.ph> wrote:
--

Sam Eslamieh

unread,
Nov 12, 2023, 6:57:02 PM11/12/23
to NV Autocrat Add-on
That's great.
How about merging directly to a google doc?

Thanks

Joe Schmidt

unread,
Nov 12, 2023, 8:05:17 PM11/12/23
to NV Autocrat Add-on
I'm afraid I don't know how to do that.  It isn't that difficult to create a template using a spreadsheet.
Reply all
Reply to author
Forward
0 new messages