I need to get the names of the six top selling Clients. This is easy to do in a chart, but I need each of them as either a variable or a text value.
If you take a look at the attached sample, the chart displays all the values all the time, even when you select a Client. This is exactly what I want to happen. However, I also want it to happen in the text boxes, and those go blank when you have one or more Clients selected.