iccubeiccube-reporting

How do I set the stroke color for column charts within IcCube


I'm looking for a way to not only draw a fill color for my column chart, but also set it's stroke so I can have a border for each slice. This would look good for forecasts / actuals comparisons, like this example:

enter image description here


Solution

  • Not sure if I fully grasp your question, but to create such a chart in icCube, you'll need to use the chart/Type: Combo and combine several column graphs.

    assumption: account is an expense account

    In this case:

    1. first column, data: actuals, color red, miscellaneous: new stack = on
    2. second column (will plot over the 1st): data: budget/forecast, color: conditional - if it's in the future > white, else it is green, set the linecolor & thickness, miscellaneous: new stack = on
    3. third column: (will plot over the 1st and 2nd): data: min(actuals & budget/forecast), color: grey

    enter image description here