hansdecocq
New Member
- Joined
- Jan 17, 2011
- Messages
- 13
Hey
My question is about “how to (re-)use the information shown in data Labels.
I produced (in Excel 2013) a simple chart and added data-labels on it.
The supporting dataset is dynamic, so if I press F9 a new dataset is generated and so is the content of the data labels.
I want to use the information shown in the data labels is a text with concatenate.
The only problem I have is how to get the information from the data label in my text e.g. What is the name of the data labels.
(=”this is an example text”& content of the data label &”The rest of the text”).
The underlined part is my problem. Someone a usable suggestion?
Regards Hans
My question is about “how to (re-)use the information shown in data Labels.
I produced (in Excel 2013) a simple chart and added data-labels on it.
The supporting dataset is dynamic, so if I press F9 a new dataset is generated and so is the content of the data labels.
I want to use the information shown in the data labels is a text with concatenate.
The only problem I have is how to get the information from the data label in my text e.g. What is the name of the data labels.
(=”this is an example text”& content of the data label &”The rest of the text”).
The underlined part is my problem. Someone a usable suggestion?
Regards Hans
