How To - Chart colors in MashZone 2.1

Good Morning,

Not entirely related to the topic, but I'm wondering whether it is possible to change the colour of a single bar in a bar chart based on its value.  Currently thresholds are shown in the background, but I would prefer that if a particular value is higher than the threshold value, then the bar colour itself changes.  Is this possible?

Dieter

Hi Dieter



To use this new feature, you need a color-column in wich you provide a color value for each datapoint in your chart.

You can fill this column with the replace-value-operator. If you have 3 "threholds" you need 3 replace-value-operators.



For example:







Now the problem is that the cartesian-charts (Line,Column,Bar) in mashzone does not differ the values by colors if you have only one dimension.

In this charts you can use the feature only with the second dimension ("More values" in the datamode).



But you can use a trick. Because you need two dimensions you need a further column in our feed (in the example "2ndDim"). This column has to be empty.

No you have to assign this column to the y-Axis and the "real dimension-column" to the "More values-axis". And here you can use your color-column for coloring.

Then we have to set the "More-Values-type" to "Grouped"

On problem remains. With this trick it is not possible to show the dimension-values direclty in the chart.

But with the legend and a userdefined tooltip you can recognize the different values.



In a pie-chart you can use the coloring-feature directly with the "criterion-coordinate".

Regards

  Thomas

 

To avoid typos you may use this snippet:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE colorscheme SYSTEM "colorscheme.dtd">
<colorscheme>
    <descriptions>
        <description language="de" name="Grau"/>
        <description language="en" name="Gray"/>
    </descriptions>
    <colors>0x8D8D8D, 0xA4A4A4, 0xBBBBBB, 0xD1D1D1</colors>
</colorscheme>

...and the colour secheme is attached!