A chart with the wrong range and a broken link
A fictional presentation compares quarterly service requests. The workbook lists four quarter labels and four values, but the selected chart source includes only three values and an unrelated total row. The chart has been linked into a presentation stored in a shared folder, while the source workbook remains in the author’s private folder. During rehearsal another user sees an old cached picture and cannot refresh it. A manager suggests adding decorative animation so the inconsistent chart is less noticeable. The exercise is a written preparation review, not permission to change shared permissions or send the presentation. The team needs accurate source ranges, clear labels and a deliberate distribution method whose update behavior is tested for the intended recipients.
1. What should be corrected in the chart before styling?
Read the worked answer
Verify the intended quarter labels, corresponding values, total treatment and series range. Inspect the resulting chart and units; decoration does not repair a mismatched or incomplete source selection.
2. How should the link problem be handled?
Read the worked answer
Choose an authorized linking, embedding or exported-output method consistent with refresh and privacy requirements. Test actual recipient access and output; do not broadly open a private folder simply to make a link work.