I'm new here so sorry in advance for protocol errors. Grateful if anyone can help me with this.
I have a Block Chart, which splits my data set into 3 dimensions. Let's call them:
- Clinical Specialty
The dimensions are ranked this way and It's a pretty chart.
I can re-order the dimensions in the block chart by promoting/demoting in ChartProperties->Dimensions and that makes a different chart that's pretty too.
However, I would like my end user to be able to reorder the dimensions once the worksheet is locked.
I've searched Google and this forum but can't find an answer. Have tried variables and calculated dimensins but I'm not sure what I'm doing. Any ideas?