1

I am trying to find a way to add a circle packing chart to a Google Sheet, using the data in a Google Sheet as its data source.

The only possibility I have found is this from DHUMANITIES http://dhumanities.appspot.com/circle_packing_index.html

But, either it no longer works or I am not configuring the data properly.

Does anyone know how to do this, create circle packing charts in Google Sheets?

18
  • 1
    I imagine that d3.js can be used, though I haven't looked closely at the "how" (yet). But if you want to graph something right now, have a look RawGraphs; click Use it now. I just created a circle packing chart using their sample data, but you can also upload your own data. You can download the final chart as svg, png or json.
    – Tedinoz
    Jan 16 '21 at 23:37
  • Thanks! Yeah, I had seen that in my searching. It does not do a very good job with data though I do see they are building a new version
    – xyz333
    Jan 19 '21 at 13:35
  • 1
    Have you looked at the answer by @Tanaike in Searchable collapsible tree using D3js in google sheet? I know that it is not "circle packing" but I was able to repeat his solution both with json in "index.html" and as a separate file (which is to say that creating the data from a Google sheet is just a step away). I've tried to adapt Tanaike's approach to Fleur Kelpin's Zoomable Circle Packing but no joy as yet. This is an intriguing question; it's got me hooked.
    – Tedinoz
    Jan 19 '21 at 22:52
  • 1
    Minor success: Refer D3 add zoom to circle pack and the answer and jFiddle by @CyrilCherian. I was able to use Tanike's methodology to create zooming circle packing in a modal screen.
    – Tedinoz
    Jan 19 '21 at 23:32
  • So cool!!. and this last reference by @CyrilCherian looks promising!! The difficulty for me with many of the examples is the challenge of configuring the data is the jsons. This last method look close to something that is usable in a Google sheet
    – xyz333
    Jan 20 '21 at 16:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.