Bubble Chart Color from CSV

  • Resolved luigibella

    (@luigibella)


    4 years, 8 months ago

    If you open the accordion panel titled ‘Multi-hazard Exposure’ you’ll see a Bubble Chart with the following CSV source:

    Hazard Type,Population Impacts (Billions of People),Economic Impacts (Trillions of Dollars),Color,Size
string,number,number,string,number
Earthquakes,2.8029288,81.5,#993405,82
 Floods ,0.628226211,74.9,#993405,75
Storm Surge,0.091488623,11.3,#ffda8f,11
Tropical Cyclone Winds,1.675425697,16.9,#ff9b29,17
Tsunamis,0.029384676,5.3,#ffda8f,5
Volcanic Eruptions,0.434527289,23.5,#ff9b29,24
Wildfires,1.216373277,27.9,#ff9b29,28

    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’.

    Thank you for your help.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter luigibella

    (@luigibella)

    4 years, 8 months ago

    I was able to get it working using the following JSON:

    {"series": {
"#993405": {"color": "#993405"},
"#ff9b29": {"color": "#ff9b29"},
"#ffda8f": {"color": "#ffda8f"}
}
}

    If there is a way to get it working automatically from the CSV value, that would be great for future use.

    Thread Starter luigibella

    (@luigibella)

    4 years, 8 months ago

    Actually, the above solution only works on the backend, not the frontend of the site.

    Thread Starter luigibella

    (@luigibella)

    4 years, 8 months ago

    Hi there!
    Just checking in to see if you know what may be causing this.
    Also, I need to force titles to always display for the Bubbles, and ideally make all of them bigger (bigger starting point size).

    Could you help me with that? Thanks so much!

    Mat

    (@mateithemeisle)

    4 years, 8 months ago

    Hello @luigibella ,

    Thank you for using Visualiser and apologies for the delayed reply!

    The correct code to be applied in the manual configuration tab would be this one:

    { "colors": ["aqua", "green", "yellow", "blue","orange"],
"bubble": {"textStyle":{
"fontSize":"10","color":"red","fontName":"cursive"}
},
"sizeAxis":{
"minSize":"20"}
}

    Please feel free to use HEX values and change the values around if you desire to. Once this code is placed correctly, save your chart and publish it, the changes should take effect on the front end too.

    Thank you for understanding and please let us know if it worked for you!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Bubble Chart Color from CSV’ is closed to new replies.