In Google Sheets, sparkline charts is known to have an option to change the last column color.

=sparkline((A1:A5),{"charttype","column";"lastcolor","green"})

What if I want to change last two column colors? Any option like this, or any workaround?

=sparkline((A1:A5),{"charttype","column";"lasttwocolor","green"})

CodePudding user response：

while this is possible to get, it is not doable with SPARKLINE. you will need to use a column chart:

after some customization it could look like your desired output:

then double-click the last two columns and set them as alt color:

CodePudding user response：

You can't achieve this within one single sparkline, however if you can tolerate an additional column to the right what you could do is to to join two sparklines together horizontally using an array literal with first sparkline containing all data points up to the penultimate one and the second containing just the last data point. Then colour the second sparkline the same as the last data point of the first and resize the column width so the bar width matches the other data points.

Obviously this won't be possible in every context.