BusinessObjects Board

Dynamic Bar Colours on Column chart

other Xcelsius - Crystal Dashboard Design
#1

Hello,

I have a fish eye component and column chart and based on the selection from the fish eye menu , the bar colours on column chart must be changed.

I tried Mapping the chart series cell to RGB/HEX values in spreadsheet( I wrote vlookup for that cell) .

but the column chart is not dynamically changing the colours.

can some one please help?

TIA
swetha

swethag (BOB member since 2014-08-06)

#2

I’ve always used hex codes stored in the spreadsheet and then mapping the color of a component to the hex code.

If you want it dynamic then you would just change the hex in the spreadsheet something like this:

=if(A1=“First”,"#ff00ff","#00ccdd")

that way if A1 = First then it will be one color, if it doesn’t equal First then it will be another color.

If you series are not changing color, then I would debug using a spreadsheet component to make sure that the IF statement is working as you expect.

Kedge

kedge (BOB member since 2007-02-14)

#3

Thanks Kedge,

I did try with If Statement and also debugged with Spreadsheet to make sure the Hex value is changing and it is changing.

So the problem is the colour cell that is mapped to the Hex value which is not triggering every time I change the Fish Eye selection.it is taking the Colour what ever that is last stored in that cell of spreadsheet.

swethag (BOB member since 2014-08-06)

#4

Are you able to share the XLF so I can have a look?

kedge (BOB member since 2007-02-14)

#5

I have attached a sample flash file
Column chart.zip (8.0 KB)

swethag (BOB member since 2014-08-06)

#6

Weird. That should be working.

What I’ve done,

  1. is open the XLF
  2. change the color of the series to be mapped to A2 to show that the char changes color to gray
  3. I then mapped the color of the series back to D9 as it was before
  4. And it is now working.

Not sure if it was still confused from a previous entry you had put into D9 and remapping it back to D9 solved it.

this is similar to what happens if you have a spreadsheet component mapped to a cell. If you change the cell formatting the spreadsheet component doesn’t pick up the changes until you re-map it to the source data again.

Either way, try following the above steps to de-map and then re-map your series colour and see if that works.

kedge (BOB member since 2007-02-14)

#7

I tried the steps you have suggested and it is not working :frowning:

swethag (BOB member since 2014-08-06)

#8

What version of dashboards are you using?

kedge (BOB member since 2007-02-14)

#9

Xcelsius 2008

swethag (BOB member since 2014-08-06)

#10

Ok I’ve got that version too. I’ll have a go in that version and see if I can make it work and share the xlf back.

kedge (BOB member since 2007-02-14)

#11

Sorry for the delay in getting back, things have been crazy at work.

I’ve just tried your dashboard on Xcelsius 2008 and I am getting the same error as you. For some reason when you change the series color of a chart at run time it does not reflect on the chart itself. where as at design time it does.

Interestingly if you map a rectangle color to the same cell when you view it in run time the rectangle changes color as expected.

So looks like it could be a bug in Xcelsius 2008. If you have the ability to upgrade to Dashboards 4.1 then I would upgrade as this bug is not in the latest version of dashboards.

Kedge

kedge (BOB member since 2007-02-14)

#12

Thanks Kedge,

that’s what I thought too ,I have ended up creating 6 charts and then dynamically control them .

swethag (BOB member since 2014-08-06)