Percentage data won't display correctly and it's driving me nuts

[Ray_Bell_DoIT]

I have a google sheet with data like

I don’t know what I did but I one chart I got it to display data like this

But the default behavior is

It’s so clunky to try and change it. The Data type allows you to change it once that freezes. I can try and go to town and change to currency format and it does nothing. I’ll refresh and it’s back to a number.

I’ve spent way too many hours on this.

It’s so easy to chart in Google Sheets as well

    const comboChart = targetSheet8.newChart()
      .setChartType(Charts.ChartType.COMBO)
      .addRange(ouRange)
      .addRange(adoptionRange)
      .addRange(staffCountRange)
      .setMergeStrategy(Charts.ChartMergeStrategy.MERGE_COLUMNS)
      .setOption('width', chartWidth)
      .setOption('title', 'XX Adoption Rate and XXX')
      .setOption('hAxis', {
        title: 'XXX',
        slantedText: true,
        slantedTextAngle: 30
      })
      .setOption('vAxes', {
        0: {
          title: 'Adoption %',
          format: '#,##0.00%'
        },
        1: {
          title: 'NXXX'
        }
      })
      .setOption('series', {
        0: {
          type: 'bars',
          targetAxisIndex: 0
        },
        1: {
          type: 'line',
          targetAxisIndex: 1
        }
      })
      .setPosition(2, chartStartColumn, 0, 0)
      .build();
    targetSheet8.insertChart(comboChart);

I’ll probably cancel my subscription soon.

[Ray_Bell_DoIT]

@Ray_Bell_DoIT

#,##0.00%

Alright I got it.