DashboardNovice
Member
File attached. In cells C8:F8, you can click a checkbox to display a data series. Last time I selected the 'Running Total' checkbox, I was able to display the related data labels which appeared above the columns.
Then I unchecked Running Total, and selected another checkbox, then I came back to 'Running Total' and checked it again which is what you see in the attached file now.
If you mouse over the data labels, it refers to the series called 'Annual Gain.'
If you select a checkbox to display a data series, then display labels, then uncheck the checkbox, the data labels remain but they are blank.
The chart references a table starting in B50.
Why does it reset? When I come back to 'Running Total' and select it again, I would expected to see the related data labels still displayed above the columns.
How can I make that happen? Is this even possible?
In short, anytime I select a checkbox for a data series, I would like for the related data labels to always display wherever I positioned them last.
Then I unchecked Running Total, and selected another checkbox, then I came back to 'Running Total' and checked it again which is what you see in the attached file now.
If you mouse over the data labels, it refers to the series called 'Annual Gain.'
If you select a checkbox to display a data series, then display labels, then uncheck the checkbox, the data labels remain but they are blank.
The chart references a table starting in B50.
Why does it reset? When I come back to 'Running Total' and select it again, I would expected to see the related data labels still displayed above the columns.
How can I make that happen? Is this even possible?
In short, anytime I select a checkbox for a data series, I would like for the related data labels to always display wherever I positioned them last.
Attachments
Last edited: