Search code examples
arraysgoogle-sheetsgraphchartslayer

In Google Sheets how do you show a grouped bar chart for only one variable?


In google sheets, I want to display grouped bars for one variable only, whilst displaying the rest of the bars as regular "fat" bars. With the way I have it set up currently, the other single valued columns scale smaller, as you can see here:

Current Visualisation

My desired effect is akin to this: enter image description here


Solution

  • can be done like this:

    enter image description here

    with stacked charts:

    enter image description here

    demo sheet