bar chart

[#1]

Hi all,

I have a question in bar chart,in my bar chart i taken a month is a dimension(x-axis) with 2 expressions(2 bars).1st expresion(1 bar) is sum(value) for max(year).2nd expresion(2nd bar)  is sum(value) for max(year)-1.please find the attacment.

The bar cahrt showing correctly, but i want to eliminate the prev year bars where the month values is null in current year.i wnat to show the bar chart like this

If again the values will be uploaded in sept month and so on the prev year bars of months will appear.

Can anyone have solution for this.please help me.

regards,

baru

[whiteline · Accepted solution]

Use this as dimension:

=aggr(if(sum({$<year ={$(=Max(year))}>}value)<>0, month), month)

[#3]

Hi whiteline,

Thanks for the solution,it is showing correctly.

I have 1 more question,how can we represent legend(2011 Budget,2011 Actual) like in the following image,

regards,

baru

[whiteline]

Sorry, can't see the image.

Append it as an attachment.

I guess you want to parametrize expression labels like this:

     =Max(year) & ' Budget'

instead of 'prev year'

and

     =Max(year) & ' Actual'

instead of 'cur.year'

[#5]

Hi whiteline,

no i am not asking about the legent captions.i want represent legend as horizontal position in my chart.Like..

regards,

baru

[whiteline]

The same problem with images.

Could you attach them as files ?

[#7]

Hi Baru,

Under the axes tab, we can change our legend position through "Dimension Axis" part.

Regards,

Kabilan K.

[#8]

Hi whiteline,

i am sorry for inconvenience.please see the above image with red mark.I want legend in horizontal view in chart.above one is the example.

regards,

baru

[whiteline]

Select this chart (click on caption).

Press and hold Ctrl+Shift (you should see red rectangles).

Move the legend rectangle with the mouse.

[#10]

Can u give a clear picture?

Regards,

Kabilan