How to scale sparkline chart relative to cell height in Google Sheets

363 Views Asked by At

In Google Sheets, the sparkline formula appears to fill a chart fully into a cell, whatever cell width and cell height is.

enter image description here

Is there any option to scale the chart height relative to the cell height, something like

=sparkline(A1:A5,{"chartheight","50% of cell height"})

I have a very tall cell which stretches the chart unrealistically, which makes it harder to understand. I have over 100 charts, which is also impractical to define ymin and ymax individually in each sparkline formula and all the charts have way different vales.

0

There are 0 best solutions below