Negative values in SPARKLINE "charttype","bar"

[vpk304]

I am using sparkline in google sheet specific to charttype as bar if all the values are positive then works fine if I have any negative values then it shows full bar attaching both the screenshot and the formula here

=SPARKLINE(P24,{"charttype","bar";"max",max(P24:P25);"color1","#AEB7C0"})

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Negative values in SPARKLINE "charttype","bar"
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.