new colour for any key Figure

[Former Member]

Hello!

I have an workbook which display the following:

-

---

2004----2005---2006

KeyFigure1-33

---

44-----32

KeyFigure2-43

---

32-----11

KeyFigure3-43

---

32-----12

KeyFigure4-66

---

99-----21

I would like display any key figure in a new Colour and a new font. It is possible with VBA?

Can anyone help me.

Thank you.

Markus

Message was edited by: mark23

[Former Member]

Hi Mark23,

Case(1): If you need to display colors statically you can do that with excel functionality itself. Applicable fro new font too.

Case(2): If you want to get colors for the keyfigures which occupy some other feilds than what you have now, you need to go for VBA. Applicable fro new font too.

Case(3): If your colors requirement is based on the analytical or decision making parameters you can go for exception functionality in BEx itself.

Check the above possibilities and please let me know your actual requirement.

[Former Member]

Hi Markus,

You could use the feature of Exception in Bex query to give different colour for key figures but will give you a maximum of 9 different colours only.

Hope it helps.

Cheers

Anurag

[former_member188325]

Hi,

did u try in workbook itself?change color and font of kfs as u like and save it as a work book.

hope this helps.

regards