Dashboard X axis Category Labels

[Former Member]

Hi,

I have the following category labels - x axis labels binned with excel cells containing label values

what i want to do is, when user select any series value from both series corresponding x axis value get inserted in to excel cell.

I try to did it by enabling insertion options i.e row, value, position etc..... but none of them inserts corresponding x axis value.

Please help!!!!!!!!!

[xjhacking · Accepted solution]

Yeah seems you need some kind of workaround to achieve this. You could use the Position insertion type to get the position. In the spreadsheet you could use a formula (VLOOKUP for example) to find the matching x-axis label.

Or you could use the Row insertion type where you include the labels in the source data. Problem here is that you cannot have the same destination cell range for both series. So you need to solve that as well.

/Xavier

[Former Member · Accepted solution]

It works by using position and vlookup

Thanks