how to fix width bar????

[bbtresoo]

Hi Guys,


I am displaying multiple charts per page and the charts are appearing in different sizes - heights are ok but the widths are varying in size based on values displayed on y-axis, where smaller y-values causes the chart width to increase relative to others. I tried applying scale and data format and also specified fixed width in Size & Overflow property but had undesired effects. I basically want the width of all charts on the page to be constant regardless of values on y-axis. Any clues?

tks in advance for ur feedbacks ;)

[MFGF]

...and also specified fixed width in Size & Overflow property but had undesired effects...

Hi,

Size and Overflow is exactly the property you need here. You haven't told us what "undesired effects" means? You simply specify the width and height of the chart, and that is the width and height that gets rendered on the page.

Cheers!

MF.

[sakthivelmani]

Hi MF,

I have a question about the Cognos bar chart. I have the revenue values in Y-axis  in millions (which are displayed like 2,000,000) but i want them to be displayed as 1M, 2M. Could you please help me with that. I was breaking my head for the whole day and couldnt find a solution.

Thanks,
Sakthi

[bbtresoo]

Hi MF,

I have a question about the Cognos bar chart. I have the revenue values in Y-axis  in millions (which are displayed like 2,000,000) but i want them to be displayed as 1M, 2M. Could you please help me with that. I was breaking my head for the whole day and couldnt find a solution.

Thanks,
Sakthi

Hi dude, I took a look on ur pb, I can give u that it gives some headache, Tell me something u really need to display M , the number only isn't sufficient? For example you can display the Number in the chart and  display  the chart title + Millions in the bracket, it's just a thought

[bbtresoo]

Hi,

Size and Overflow is exactly the property you need here. You haven't told us what "undesired effects" means? You simply specify the width and height of the chart, and that is the width and height that gets rendered on the page.

Cheers!

MF.

The matter here isn't really the width and the height of the chart.  the matter here is the area inside de chart.

In my case I had to display the top 10 contributors in the chart, it works nice , the area is well filled. when I modify my filter and want to display the top 3, cognos increases automatically the bar width to fill all the chart area. I had in mind to play with  conditionnal styles, in order to modify the bar width depending on what values I get but it's not possible, I have limited options with conditionnal styles

[sakthivelmani]

Thank you, bbtresoo.

I am okay with displaying it the way you suggest. Could you please tell me how i can do that ?


Thanks again,
Sakthi

[bbtresoo]

Actually, You need to click on ur default measure in the chart  and set the properties .

set data format as number

set No.of Decimal Places as 2
set scale  as -6

Give it a try and let me know

[sakthivelmani]

Hi bbtresoo,

You nailed it. Thanks a lot. It works perfectly as expected. I tried everything earlier but did not know what the scale part does.

Many Thanks,
Sakthi

[bbtresoo]

u welcome :)

[MFGF]

Actually, You need to click on ur default measure in the chart  and set the properties .

set data format as number

set No.of Decimal Places as 2
set scale  as -6

Give it a try and let me know

Great answer! That gets an "Applaud" from me! :)