SubscribeImprove your in-cell charts with colors and negative values
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?
| Delicious | Stumble it |
« Prev | Home | Awesome folks at flickr introduce instant zoom for photos »
Have an Excel Question?
Trackbacks & Pingbacks
- Pingback by Display symbols in excel chart axis | Pointy Haired Dilbert - Chandoo.org on August 21, 2008 @ 6:15 pm
- Pingback by What is the best micro charting tool for Excel? - 7 Alternatives Reviewed | Pointy Haired Dilbert - Chandoo.org on September 5, 2008 @ 1:35 pm
Comments
RSS feed for comments on this post. TrackBack URI
Leave a comment
Join Our Community
Interesting idea. You could also use a border on the boundary between the two cells to serve as an axis (though it’s not really necessary).
@Jon… thanks, yeah, I had the border, but it kinda looked odd, so removed it.
It’s always easier to improve on something good rather than invent it from scratch - I didn’t expect Chandoo to post it though! I also wanted to add an x-axis but the point of these charts is simplicity so I left it out.
Hi Chandoo,
Thanks for the excel tips.
I’ve been trying to create a heatmap on a selected grid of numbers in a spreadsheet (basically select the grid of any size and hit a keyboard shortcut to run a macro which will create the heatmap)…
The color shades will be from blue to red (blue being the smallest and red being the highest)
Any ideas?
Speedball, try downloading Poptools (free) as it has that function but in shades from white to red, white to blue etc.
http://www.cse.csiro.au/poptools/
It has a heap of science functions but halfway doen the list is the function you are after.
To do exactly what you are after, try http://www.prodomosua.eu/zips/stile.exe
It is in Italian and is an add-in (prodomosua is the password) - also free
While you are at it, have a look at the prodomosua site for some great add-ins http://www.prodomosua.eu/ppage02.html
Speedball, try downloading Poptools (free) as it has that function but in shades from white to red, white to blue etc.
http://www.cse.csiro.au/poptools/
It has a heap of science functions but halfway doesn’t the list is the function you are after.
To do exactly what you are after, try
http://www.prodomosua.eu/zips/stile.exe
It is in Italian and is an add-in (prodomosua is the password) - also free
While you are at it, have a look at the prodomosua site for some great add-ins http://www.prodomosua.eu/ppage02.html
@Speedball : looks like you have few answers from Tony. Let us know if this works for you. Otherwise I can write a macro that can be used to generate heatmaps. Btw, if the heatmap should have 4 or less colors, you can do that with conditional formatting, no need for vba.
http://chandoo.org/wp/2008/07/09/partition-charts-excel-pie-alternative-visualization-hack/
@tony.. thanks alot for sharing these links, I really liked the prodomosua site and will test some of these add-ins from my windows laptop.
Thanks for the links Tony and Chandoo…
@Tony I think stile from prodomosua is exactly what I’m looking for, but downloading exe’s is blocked at my firm
I would give it a shot at my home and if the source is available that would be excellent…
Anyway these plugins are really cool and would definitely like to try some of those…
@Chandoo unfortunately I want more than 4 colors…rather shades!
else CF would have done the trick…
If stile’s source is not available I might have to fall back on your skills
Looks sweet!
Could you tell me where to get this “bar” character? I didn’t find it yet, and copy pasting is quite complicated to do!
Thx