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

57 Views Asked by At

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

1

There are 1 best solutions below

4
On BEST ANSWER

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