PPTools
Shape Styles brings the power of styles to PowerPoint. Apply complex formatting with a single click
Merge Excel, CSV or tab-delimited data into PowerPoint presentations to create certificates, awards presentations, personalized presentations and more
FixLinks prevents broken links when you distribute PowerPoint presentations
Optimizer saves disk space and bandwidth, shrinks your PowerPoint presentations to the right size for email, screenshow or printing
PPT2HTML gives you full control of PowerPoint HTML output, helps meet Section 508 accessibility requirements
Prep4PDF preserves interactivity in PowerPoint presentations when you convert to PDF
Image Export converts PowerPoint slides to JPG, PNG, GIF, WMF and more
|
Problem
After editing an MSGraph chart's label text, it no longer reflects the values in the chart's data sheet. The chart itself (ie, the bar or line) follows the data in the sheet but the labels no longer change when the data does.
Solution
- Select the data series:
- Click its pie slice/line/bar/etc (but not the data label itself) on the chart or ...
- Choose the series from the Chart Objects listbox on the Standard toolbar. Be sure to choose "Series XXX" and not "XXX Data Labels"
- Choose Format, Selected Data series from the main menu bar
- Click the "Data Labels" tab
- In the "Data Labels" area, click "None" (PowerPoint 2000 and previous) or remove the check marks next to the automatic text options you've selected (PowerPoint 2002 and later) then click OK. This turns data labels off completely
- Once again choose Format, Selected Data series, go to the "Data Labels" tab. Re-select your preferred labeling options to turn the data labels back on again. The labels now reflect the data in the data sheet.
Search terms:chart,label,edit,manual,data,sheet
|
Contents © 1995-2008 Stephen Rindsberg, Rindsberg Photography, Inc. and members of the MS PowerPoint MVP team. You may link to this page but any form of unauthorized reproduction of this page's contents is expressly forbidden.
|
Español Deutsch Français Português Italiano Nederlands Greek Japanese Korean Chinese
|
|
