Dashboard column line chart with line on top

[Former Member]

Hi

i use in my Dashboard project a column line chart  to vien two mesure ( pic1)

the business needs want to view this chart  like this (pic2) its means that they want to vien the line in the top

How make this requirement  please.

thanks

[former_member182541]

Hi,

I hope you have taken both the series in the same axis or the column value might be higher than the line. Try to use primary and secondary axis and check or else provide us the sample data, we can guide you how to do this.

--SumanT

[Former Member]

Hi,

i have two series :

1-salary

2-evolution rate of salary

i tried to use primary and secondary axis but no succes

this is a sample of data:

2010     1400     0%

2011     1400     0%

2012     1260     -0.9%

2013     1300     1.03%

2014     1480     1.14%

Any idea ?

Thanks

[kohesco]

Hi,

It seems stupid but could do the trick,

put formula behind your evoultion rate

=max(salary)+50(fordistance)+ evoultion rate (labels = no show)

add text fields above chart (showing the labels)

grtz

Koen

[Former Member]

Hi,

for line it work, but for showing labels he dont works because the labels should be positioned relative to the rate and the  data is loaded evry refrech of my bex query.

Any idea

[kohesco]

Hi,

if the number of label doesnot change, it will be okay, you can map accordingly.  In the other case ... crap , two graphs above each other ?

[Former Member]

Hi,

sorry but i dont understand why it wll be okay if the number of label doesnt change.

height is dynamic for labels

[kohesco]

Hi,

because we take the max(height) into account.

Grtz

Koen

[Former Member]

Hi,

but all labels will be the same height ?

Thanks

[kohesco]

Hi,

the idea was to have your line above the bars, I thought, so when you add your values with the max(height) It will be okay (using the same series) the line will have the correct shape, because you'll add the same value to each label.  Only the number/value you will represent will be wrong.  thats why you have to map the textlabels to the correct values not the ones use for representing.

Grtz

Koen

[Former Member]

hi,

but how can map textlabel to the correct values ?

Thnks

[kohesco]

if you have 5 labels: Cell A1, B1, C1 D1, E1, F1

you use 5 components: text

and place them at the top of your chart, textcomponent mapped to A1 and above the first point in the line. and so one and one.  If your number of labels is always the same, you will have not issues. in the other case, >> crap