Skip to Content
avatar image
Former Member

Dashboard X axis Category Labels

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!!!!!!!!!

CL.png (3.3 kB)
Cl2.png (11.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2015 at 06:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded