Forum Discussion
Solved
Powerpoint text box linked to data table
Hello I am trying to fix up a PowerPoint document containing a chart. We have a chart (radar) within the document with some embedded data (not linked to external Excel file) We calculate a...
- So I managed to figure this one out...
1. Highlight the chart itself within the PowerPoint document to enable the chart design ribbon
2. Select the "Add Chart Element drop down button, (far left) > Data Labels > More Data Label Options
3. On the right pane, Format Data Labels, tick "Value from cells", and pick the cell you wish to show
4. You should get a bunch of new labels, some of which you do not want to see. These seem to group together and don’t appear to be individually editable, but they can be resized separately, which then allows you to remove them individually by cut/deleting!
5. Obviously keep the label you created that was pointed at the cell you want to show the value for. You may need to untick a few other options like "value" and "Show Leader Lines", as well as turning off autosizing so the box doesn’t jump around the page when a new value updates automatically.
So I managed to figure this one out...
1. Highlight the chart itself within the PowerPoint document to enable the chart design ribbon
2. Select the "Add Chart Element drop down button, (far left) > Data Labels > More Data Label Options
3. On the right pane, Format Data Labels, tick "Value from cells", and pick the cell you wish to show
4. You should get a bunch of new labels, some of which you do not want to see. These seem to group together and don’t appear to be individually editable, but they can be resized separately, which then allows you to remove them individually by cut/deleting!
5. Obviously keep the label you created that was pointed at the cell you want to show the value for. You may need to untick a few other options like "value" and "Show Leader Lines", as well as turning off autosizing so the box doesn’t jump around the page when a new value updates automatically.
1. Highlight the chart itself within the PowerPoint document to enable the chart design ribbon
2. Select the "Add Chart Element drop down button, (far left) > Data Labels > More Data Label Options
3. On the right pane, Format Data Labels, tick "Value from cells", and pick the cell you wish to show
4. You should get a bunch of new labels, some of which you do not want to see. These seem to group together and don’t appear to be individually editable, but they can be resized separately, which then allows you to remove them individually by cut/deleting!
5. Obviously keep the label you created that was pointed at the cell you want to show the value for. You may need to untick a few other options like "value" and "Show Leader Lines", as well as turning off autosizing so the box doesn’t jump around the page when a new value updates automatically.