#2 Color Shift in Reverse Bullet Charts

closed-fixed
5
2014-08-16
2008-10-31
Grant
No

Sparkline Chart Module
Reverse Bullet Chart

Environment
Windows XP – Excel 2003 SP 3

Problem Description
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.

Reproduction Steps
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.

Expected Behavior
Shapes for both bullet charts should follow the same color scheme.

Discussion

  • Fabrice Rimlinger

    • labels: --> Interface (example)
    • assigned_to: nobody --> frimlinger
     
  • Fabrice Rimlinger

    • status: open --> closed
     
  • Fabrice Rimlinger

    Solved - issue related to instruction "tint_and_shade" not accepted by XL2000.

    Added "application.version<11" test to solve the compatibility issue.

     
  • Grant

    Grant - 2008-11-04

    Item now working correctly.

     
  • Grant

    Grant - 2008-11-04
    • status: closed --> open
     
  • Fabrice Rimlinger

    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks