Dashboard X axis Category Labels
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.
Xavier Hacking replied
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.