I have some data that is coded.
In other words, for a code such as 99914, it would translate to a procedure such as "CA Scan: pelvis."
On my histogram, I am doing a count of the codes. For a cleaner look, it makes more sense to use the code number as labels than the actual descriptions on the chart. Once I click on a specific number in the histogram, it narrows down to that specific code to where that is the only bar showing. When this happens I would like a text box some where that can display that code's description.
Let me know if I need to clarify anything else.
I'm presuming you're bringing in a table that relates codes to procedure names...if not, you'll need to do that first.
To do this, create a text box with an expression like:
='Procedure Name: '&[Procedure_Name]
Then, on the layout tab of the Text Box Properties dialog, select "Conditional" and use this expression:
This will only display the text box with the procedure name when you have 1 procedure code selected. Let me know if this helps!