Waterfall Chart
Box and Whiskers
Archive for Monday, June 16th, 2008
Area Chart - Invert if Negative
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
A visitor to the Microsoft newsgroups wanted his area chart to show a different color for positive and negative values. This is easy enough to do in a column chart. One technique is simply to use the Invert if Negative formatting option, the other it to make a conditional chart with one series for positive [...]
Posted: Monday, June 16th, 2008 under Charting Principles, Data Techniques, Formatting.
Comments: 7
