{"id":14926822,"date":"2021-10-01T02:35:32","date_gmt":"2021-10-01T02:35:32","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/bubble-chart-color-from-csv\/"},"modified":"2021-10-01T02:35:32","modified_gmt":"2021-10-01T02:35:32","slug":"bubble-chart-color-from-csv","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/bubble-chart-color-from-csv\/","title":{"rendered":"Bubble Chart Color from CSV"},"content":{"rendered":"

If you open the accordion panel titled ‘Multi-hazard Exposure’ you’ll see a Bubble Chart with the following CSV source:<\/p>\n

Hazard Type,Population Impacts (Billions of People),Economic Impacts (Trillions of Dollars),Color,Size\nstring,number,number,string,number\nEarthquakes,2.8029288,81.5,#993405,82\n Floods ,0.628226211,74.9,#993405,75\nStorm Surge,0.091488623,11.3,#ffda8f,11\nTropical Cyclone Winds,1.675425697,16.9,#ff9b29,17\nTsunamis,0.029384676,5.3,#ffda8f,5\nVolcanic Eruptions,0.434527289,23.5,#ff9b29,24\nWildfires,1.216373277,27.9,#ff9b29,28<\/code><\/pre>\n
The issue is that the colors in column 4 are not being displayed as the color of the bubble, and I don’t see a Series option on the backend to mark this column to be used for ‘Style’.<\/p>\n
Thank you for your help.<\/p>\n","protected":false},"template":"","class_list":["post-14926822","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14926822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14926822\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14926822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}