Sparkline Chart Module
Reverse Bullet Chart
Windows XP – Excel 2003 SP 3
Applies to Reverse Bullet Chart
When creating the share ahead of the good. The shape created has the wrong color. Whereas the Bullet Chart creates a shape with a color of Red 255, Green 255, Blue 255, the Reverse Bullet Chart creates a shape with a color of Red 236, Green 236, Blue 236.
While its difficult to see on the screen, but it shows up very clear when printed.
Zoom in to 400%
In one cell put the following formula:
=revbulletchart(12,25,25 * 1.2,20 * 0.8,20)
In another one cell put the following formula:
=bulletchart(12,25,25 * 1.2,20,20 * 0.8)
At this magnification you should see a slight color shift between the areas considered good.
Shapes for both bullet charts should follow the same color scheme.
Log in to post a comment.