Google Sheets – Preserve Spreadsheet Chart Format When Exporting

google sheets

I built a Table Chart in Google Sheets, and all numerical values except for the last column are displayed as percentages, which is a behaviour I need and want.

View of my sheet (sample of the Table chart):

sheet view

I later published to the web the sheet containing my chart to my GoogleApp. To my dismay, only the 1st column was displayed as percent, and the other were displayed as decimal numbers.

View inside my app (sample of the Table chart):

app view

The developers I work with told me they are just opening the spreadsheet file inside the app from its URL in an iframe tag. What might have caused this difference of behavior between my spreadsheet and its export?

Ok, so I have solved my problem. I have absolutely no clue why there was an issue, and why my fix worked.

All I did was enter the advanced setting of the Chart, and reduce the range of the data I was using. Basically, reducing the range from A1:F300 to A1:F51 was enough. Once I did this, the exported chart in my GoogleApp started being compliant to the one I have in my sheet. The original range had a lot of empty cells, but my new range still has some. Furthermore, a range of 1800 cells doesn't seem that unreasonable to compute for Google Sheet.

Best Answer

Ok, so I have solved my problem. I have absolutely no clue why there was an issue, and why my fix worked.

All I did was enter the advanced setting of the Chart, and reduce the range of the data I was using. Basically, reducing the range from A1:F300 to A1:F51 was enough. Once I did this, the exported chart in my GoogleApp started being compliant to the one I have in my sheet. The original range had a lot of empty cells, but my new range still has some. Furthermore, a range of 1800 cells doesn't seem that unreasonable to compute for Google Sheet.

Related Topic