Insert and format charts

I need the semester enrollment chart embedded and styled in the class handbook. Insert the latest enrollment chart from the linked spreadsheet into the handbook, apply the handbook’s caption style, set the chart to update automatically when the sheet changes, size it to fit the page width without breaking the paragraph flow, and add alt text describing the trend for accessibility. Confirm the chart refreshes and provide the doc link.

Before we publish the handbook, make the charts easy to scan. Pull the enrollment, grade distribution, and participation charts into one Results section, add concise captions with the key takeaway and percentage figures up top, ensure each chart is a consistent width and font size, and flag any charts whose source ranges look like they include totals rows that would mislead a reviewer.

I inserted the grade distribution chart into the course guide, and it shows last semester’s numbers instead of the live sheet. The program director, Jorge, expects current figures for accreditation. I don’t know if the link broke, the spreadsheet range moved, or I set a static image. Diagnose the most likely cause and tell me the quickest way to restore a live-updating chart so Jorge can sign off today.

Across multiple handbooks I keep embedding charts that later show stale or wrong ranges, and reviewers catch the errors during sign-off, costing credibility. Is this a pattern of poor source management, wrong embedding options, or team permissions problems? Recommend the single habit change or check to make embedding charts reliable going forward.