Stacked Combo Chart?

Nevada Smith

unread,

Sep 17, 2019, 6:50:42 PM9/17/19

to Google Visualization API

I'm currently using Excel to create a "stacked combo chart" and was wondering if it's possible to use Google Charts instead? If so, how?

sales-by-region-chart.PNG

Nevada Smith

unread,

Sep 17, 2019, 6:59:24 PM9/17/19

to Google Visualization API

This is also known as a "Clustered Stacked Bar Chart"

Martin Noyes

unread,

Sep 17, 2019, 7:06:58 PM9/17/19

to Google Visualization API

On Tuesday, September 17, 2019 at 6:50:42 PM UTC-4, Nevada Smith wrote:

I'm currently using Excel to create a "stacked combo chart" and was wondering if it's possible to use Google Charts instead? If so, how?

Nevada,

That's a very good question. I'm pursuing that sort of thing myself. So far, all I've come up with is a Node.js based solution that adds a taskpane into Excel. But that means everything is coming from the Node.js server on your own machine and it's unclear how to get the Javascript onto the server so that the call could be made to invoke Google Charts from the Web while referencing the necessary ranges in Excel to populate the chart. It's still a work in progress. Let us know if you come up with a different solution.

Martin

Reply all

Reply to author

Forward