How to add chart alt text in Google Sheets and Excel

1. Manual methods: adding chart alt text by hand

Before you automate anything, you need to understand the exact clicks an agent would perform. Here is how to add alt text to charts manually in both Excel and Google Sheets.

‍

1.1 Excel (Windows and Mac)

Microsoft’s official guidance on alt text is here: https://support.microsoft.com/en-us/office/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-a742-6a75d9449952

Step-by-step for a chart in Excel:

1. Create or select your chart
   • Insert your chart as usual from the Insert tab.
   • Click once on the chart border so the entire chart is selected, not a single series.
2. Open the Alt Text pane
   • Right-click the chart border.
   • Choose Edit Alt Text (Windows) or View/Edit Alt Text (Mac).
   • Alternatively, go to the Chart Format (or Format) tab on the ribbon and select Alt Text.
3. Write a concise, meaningful description
   • In the Alt Text pane, leave the title field blank unless you have a strong reason to use it.
   • In the description box, type 1–2 sentences that cover:
     • What the chart type is (for example, line chart of monthly revenue).
     • The main trend, outliers, or takeaway.
     • Where the source data is (for example, data in sheet Sales_Q1, cells A2:D13).
   • Example: Revenue by month line chart showing steady growth from January to June, then a spike in July. Source data in Sales_Q1 sheet, range A2:D13.
4. Mark purely decorative visuals
   • If the chart is just decorative (rare for charts), check Mark as decorative so screen readers skip it.
5. Repeat for every chart
   • Move through each chart in the workbook and repeat the process. This is exactly the repetitive loop an AI agent can later take over.

‍

Pros (manual Excel):

• Maximum control over nuance and wording.
• Ensures compliance with internal style guidelines.

‍

Cons:

• Painfully repetitive if you maintain many dashboards.
• Easy to forget a chart or copy‑paste the wrong description.

‍

1.2 Google Sheets

Google’s help on alt text in Docs, Sheets, and Slides: https://support.google.com/docs/answer/9694190

‍

Step-by-step for a chart in Google Sheets:

1. Insert or select your chart
   • Create your chart via Insert > Chart.
   • Click once on the chart to select the whole object.
2. Open the Alt text dialog
   • Right-click the chart and select Alt text.
   • Or use the top menu: Format > Alt text (in some interfaces, Insert > Alt text).
3. Fill in title and description
   • Title (optional but useful in Sheets): short label such as Monthly leads by channel.
   • Description (required for accessibility): 1–2 sentences capturing:
     • Chart type and metric (bar chart of leads by channel).
     • Key patterns (search leads double other channels; social flat).
     • Where the data sits (Data in Leads_2025 sheet, A1:D13).
   • Example: Bar chart showing monthly leads by acquisition channel. Search consistently outperforms social and email. Data in Leads_2025 sheet, cells A1:D13.
4. Keep it focused
   • Avoid purely visual adjectives that don’t add meaning.
   • Do not repeat nearby body text word for word.

‍

Pros (manual Sheets):

• Simple for occasional charts.
• Works in browser on any OS.

‍

Cons:

• Cumbersome for large, multi‑tab reports.
• Easy to miss a chart when deadlines are tight.

‍

2. No‑code automation methods

If you manage recurring reports, you can reduce the manual effort before you ever touch an AI agent.

‍

2.1 Use templates and checklists

1. Create a reporting template workbook in Excel and Google Sheets.
2. Pre‑insert chart objects with placeholder alt text fields.
3. Add a checklist tab called Accessibility QA:
   • Columns: Sheet name, Chart name, Alt text added (Y/N), Reviewer, Date.
4. Before sending any report, a junior team member or VA runs through the checklist and fills alt text.

‍

Pros:

• Zero tooling overhead.
• Encodes best practices into your templates.

‍

Cons:

• Still relies on human discipline.
• Time cost scales linearly with number of charts.

‍

2.2 Use no‑code automation tools around your files

Tools like Zapier, Make, or Power Automate cannot directly edit chart alt text today, but they can orchestrate the workflow around it:

1. Trigger on file events
   • Trigger: when a new Excel file is saved in SharePoint/OneDrive, or a new Google Sheet is added to a Drive folder.
2. Generate draft descriptions
   • The automation sends metadata (file name, sheet name, maybe CSV data extracted via an API or export) to an LLM to generate suggested alt text for each chart.
3. Deliver tasks to humans
   • Post the LLM‑generated suggestions into a task tool (Asana, ClickUp, Jira) for a content owner to paste into Excel or Sheets.

‍

Pros:

• Cuts the thinking time: humans mainly copy, tweak, and paste.
• Useful stepping stone before full AI agents.

‍

Cons:

• Still requires manual clicks inside Excel and Sheets.
• Integrations can be brittle across enterprise environments.

‍

2.3 Use Office built‑in automatic alt text (Excel only)

Excel has an automatic alt text feature using Microsoft AI.

1. In Excel, open File > Options > Accessibility.
2. Under Alt Text, enable the option to generate alt text using AI.
3. Insert or select a chart, then open the Alt Text pane.
4. Let Excel suggest a description and then refine it manually to mention the main trend and data location.

‍

Pros:

• Very low friction; no extra tools.

‍

Cons:

• Descriptions can be generic or inaccurate.
• Does not know your business context or reporting standards.

‍

3. Scaling with AI computer agents (Simular)

For agencies, sales ops, or marketing teams shipping dozens of spreadsheets every week, the real win is to offload the entire repetitive sequence to an AI computer agent that behaves like a tireless teammate.

‍

3.1 Agent pattern: alt text sweeper for Excel

With a desktop‑capable AI agent such as Simular Pro, you can:

1. Configure the workflow
   • Define a playbook: open a specified Excel file, iterate through each sheet, select each chart object, open the Alt Text pane, and read related data ranges.
2. Let the agent read the data
   • The agent can navigate from the chart to its underlying table (using Select Data or linked ranges), scan headers and values, and infer patterns.
3. Generate and apply alt text
   • For each chart, the agent drafts 1–2 sentences describing chart type, key trend, and table location, then pastes it into the Alt Text description box.
4. Run at scale
   • Drop 10, 50, or 200 workbooks into a folder; the agent sweeps through them in a single run.

‍

Pros:

• True end‑to‑end automation: no human clicking.
• Consistent phrasing across all reports.
• Transparent execution in Simular Pro: you can inspect every step.

‍

Cons:

• Needs careful initial configuration and testing.
• Best suited once you have stable reporting templates.

‍

3.2 Agent pattern: cross‑suite alt text for Google Sheets

Even though Sheets lives in the browser, a Simular agent can still operate:

1. The agent launches a browser, opens the target Google Sheet, and signs in.
2. It selects each chart, opens the Alt text dialog, and inspects the associated data range via the chart editor.
3. Using its language capabilities, it writes concise descriptions tailored to your audience (for example, campaign performance summary for a client).
4. It repeats this across multiple Sheets files listed in a tracker or Drive folder.

‍

Pros:

• Works across both Google Sheets and Excel workflows from one agent.
• Perfect for agencies managing many client workbooks.

‍

Cons:

• Needs stable folder structures and clear naming.
• Browser UI changes require occasional agent updates.

‍

3.3 Hybrid approach: human‑in‑the‑loop QA

For regulated industries or high‑stakes executive reporting, combine AI speed with human judgment:

1. Simular fills alt text across all charts.
2. It exports a summary sheet listing: file, sheet, chart ID, and alt text.
3. A human reviewer spot‑checks or edits critical lines.
4. The agent can re‑apply corrected versions if you maintain a mapping.

This hybrid model keeps you compliant and on brand, while the agent absorbs 90 percent of the drudgery.

For official reference material as you design your workflows, lean on:

• Microsoft Excel alt text docs: https://support.microsoft.com/en-us/office/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-a742-6a75d9449952
• Google Docs, Sheets, Slides alt text docs: https://support.google.com/docs/answer/9694190