Sparklines for negative values

Question

I would like to show sparklines for a balance that is supposed to be negative. So when there is an increase in the negative balance, I want the sparkline to show an upward tick. I know it's possible because I have seen it, but can't figure out how to change.

Ryan

Answer 1

I also would find this feature useful (to show increasing costs (negative on the spreadsheet) as a rising sparkline). Similar to toggling left-to-right, there should be a toggle to flip the sparkline over top-to-bottom!

A workaround is to have a separate row (or column) of data that inverts the values (to positive) (e.g. B1=-A1), and create a sparkline of that.

Answer 2

Thanks for the suggestion ediardp. That, however, simply causes the same sparkline to read from right-to-left rather than left-to-right. That does not create an uptick when the value goes down.

Question still unanswered.

Answer 3

Hi,

Go to the page suggested by Sachin and click on Create Sparklines, once you created it, go to the sparkline, click on design, click on Axix (is within the group), checkj pilot data from right to left

Answer 4

Thank you, but this does not answer the question. I want the sparkline to show an uptick when my negative value increases from -40 to -41. If you think I am missing that in the customize help section, can you point me specifically to where it's addressed? Thanks.

Ryan

Answer 5

Refer the Customize sparklines section given in the following link for help:

http://office.microsoft.com/en-us/excel-help/use-sparklines-to-show-data-trends-HA010354892.aspx

---

Sachin Shetty