In response to Making Incell charts better article, reader Tony mailed me an excel sheet in which he has modified the charts to display colors and negative values. This is pretty cool. Take a look at the chart below:

MS Excel Incell charts with colors and negative values
The trick lies in displaying the charts in 2 rows, one for positive values and another for negative values and then coloring positive row with green and negative row with red. See aside.
Download this example sheet to experiment with incell charts.
Thanks Tony for sharing this with our readers 🙂
What is your favorite charting trick?
One Response to “Loan Amortization Schedule in Excel – FREE Template”
The balance formula as given doesnt seem to work on my excel