How to Add Weather Data into Microsoft PowerPoint

February 10, 2026

Microsoft PowerPoint can display weather charts that are linked to live or regularly refreshed weather data.

The most reliable modern workflow is to:

  1. Load Visual Crossing weather data into Microsoft Excel.
  2. Create the weather chart in Excel.
  3. Link that chart into PowerPoint.
  4. Refresh the weather data in Excel.
  5. Update the linked chart in PowerPoint.

This separates the weather-data connection from the presentation itself. Excel handles the Weather API and data transformation, while PowerPoint displays the resulting chart.

The Visual Crossing Weather API provides historical weather, current conditions, and forecast weather that can be loaded into Excel using Power Query.

If you prefer to explore or download weather data without writing code, see Visual Crossing Weather Data.

To get started, sign up for a free Visual Crossing account.

Why use Excel with PowerPoint?

PowerPoint can create charts directly, but Excel is better suited to retrieving and refreshing external data.

Microsoft recommends creating the chart in Excel when the underlying data changes regularly and linking the resulting chart into PowerPoint. This allows the presentation to reflect updated Excel data without rebuilding the chart manually.

This approach is especially useful for:

  • Weather forecasts
  • Historical weather reports
  • Event planning presentations
  • Operations dashboards
  • Sales and weather analysis
  • Energy reports
  • Agricultural reports
  • Transportation briefings
  • Executive presentations

Step 1 – Load weather data into Excel

First, create an Excel workbook that retrieves your Visual Crossing weather data.

For a simple CSV-based workflow, see:

How to Load Weather Data into Microsoft Excel Using a Web Query Data Connection

For a more flexible Power Query workflow using JSON, parameters, and Power Query credentials, see:

Import Weather API JSON into Excel Using Power Query

For this example, suppose Excel contains a daily forecast table such as:

Date          Max Temp    Min Temp    Precip
2026-08-21       84.2        65.1      0.00
2026-08-22       82.5        66.4      0.12
2026-08-23       79.7        64.9      0.48
2026-08-24       81.3        63.8      0.05

The exact weather fields you include depend on the presentation you want to build.

Step 2 – Create a chart in Excel

Select the weather data that you want to visualize.

For example:

Date
Max Temp
Min Temp

Then in Excel:

  1. Select the data.
  2. Open the Insert tab.
  3. Choose Line Chart.
  4. Select the desired chart style.

You might create a chart showing:

Daily Maximum Temperature
Daily Minimum Temperature

with the date on the horizontal axis.

Add a descriptive chart title such as:

Weather Forecast

or:

London 7-Day Weather Forecast

Format the chart in Excel before moving it into PowerPoint.

Step 3 – Save the Excel workbook

Save the Excel workbook before linking the chart into PowerPoint.

For example:

WeatherForecast.xlsx

The workbook must remain accessible to PowerPoint for the link to continue working.

You can store the workbook:

  • On your local computer
  • On a shared network location
  • In OneDrive or another supported shared location

If the workbook is moved, renamed, or deleted later, PowerPoint may no longer be able to update the linked chart.

Step 4 – Copy the Excel chart

In Excel:

  1. Select the chart.
  2. Right-click the chart.
  3. Select Copy.

You can also use:

Ctrl+C

on Windows.

Now switch to your PowerPoint presentation.

Create or open the slide where you want the weather chart.

Paste the chart using one of PowerPoint’s linked-data paste options.

Depending on the Microsoft 365 version and theme, these may appear as:

Use Destination Theme & Link Data

or:

Keep Source Formatting & Link Data

The important part is:

Link Data

This tells PowerPoint to maintain a connection to the original Excel workbook rather than embedding an independent copy of the chart.

A linked chart can then be updated when the Excel data changes.

Linked versus embedded charts

PowerPoint supports several ways to paste Excel charts.

Linked chart

A linked chart keeps a connection to the Excel workbook.

Use this when the weather data will change.

For example:

Weather API
    ↓
Excel Power Query
    ↓
Excel chart
    ↓
Linked PowerPoint chart

This is the recommended approach for a regularly updated forecast or dashboard.

Embedded chart

An embedded chart stores a copy of the Excel data inside the PowerPoint presentation.

Changes to the original Excel workbook will no longer automatically update the embedded copy.

Embedding is useful when you want the PowerPoint file to be completely self-contained.

Picture

You can also paste the chart as an image.

This produces a static result and has no link to Excel.

Use this when you want a fixed snapshot rather than a refreshable chart.

Step 6 – Refresh the weather data

When you want new weather data, open the Excel workbook.

Use:

Data → Refresh All

Excel will rerun the Power Query or web query and retrieve updated Visual Crossing weather data.

If your chart is based on the refreshed Excel table, the Excel chart will update automatically.

Step 7 – Update the chart in PowerPoint

After the Excel data has been refreshed, return to PowerPoint.

Select or right-click the linked chart and choose:

Update Link

or, depending on the version of PowerPoint:

Refresh Data

PowerPoint will retrieve the latest chart information from the linked Excel workbook.

Microsoft documents this linked-chart workflow specifically for presentations that need to reflect updated Excel data.

Example: build a weather forecast slide

Suppose your Excel workbook retrieves:

datetime
tempmax
tempmin
precipprob
conditions

You could create a PowerPoint slide containing:

Temperature chart

A line chart with:

Date
Maximum Temperature
Minimum Temperature

Precipitation chart

A second chart showing:

Date
Precipitation Probability

Conditions summary

A small table could show:

Friday      Partially cloudy
Saturday    Rain
Sunday      Rain, Partially cloudy
Monday      Clear

This creates a presentation that can be reused while the underlying forecast data changes.

Create the Weather API request

The Visual Crossing Timeline Weather API uses this basic request structure:

/timeline/[location]/[date1]/[date2]

For a forecast, the dates can be omitted.

For example:

https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/London,UK?unitGroup=metric&include=days&key=YOUR_API_KEY

To retrieve only the fields needed for a basic chart:

elements=datetime,tempmax,tempmin,precipprob,conditions

A complete request might therefore be:

https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/London,UK?unitGroup=metric&include=days&elements=datetime,tempmax,tempmin,precipprob,conditions&key=YOUR_API_KEY

For the full API reference, see the Timeline Weather API documentation.

Use historical weather instead of forecast data

The same approach can be used for historical weather.

For example:

https://weather.visualcrossing.com/VisualCrossingWebServices/rest/services/timeline/London,UK/2026-07-01/2026-07-31?unitGroup=metric&include=days&key=YOUR_API_KEY

You could then create PowerPoint charts showing:

  • Daily high and low temperatures
  • Daily precipitation
  • Wind speed
  • Humidity
  • Solar radiation
  • Snow
  • Weather conditions

This can be useful for reports and historical analysis.

Use worksheet parameters

A useful Excel Power Query design is to store parameters such as:

Location
StartDate
EndDate
UnitGroup

in worksheet cells.

For example:

ParameterValue
LocationLondon, UK
StartDate2026-08-21
EndDate
UnitGroupmetric

Changing the location or date values and refreshing the workbook then updates the Excel data and chart.

The linked PowerPoint presentation can subsequently be refreshed from that updated chart.

For a parameterized example, see Import Weather API JSON into Excel Using Power Query.

API key security

The Visual Crossing Weather API requires an API key.

A simple Excel web query may contain a URL such as:

?key=YOUR_API_KEY

If the full API URL is stored in a workbook, users who receive the workbook may be able to view the key.

Treat your API key as a credential.

For a more secure Power Query configuration, use Power Query’s Web API credential support with:

ApiKeyName = "key"

rather than embedding the key directly into the M query.

See Import Weather API JSON into Excel Using Power Query for a complete example.

Be careful when sharing the presentation

A linked PowerPoint presentation depends on the source Excel workbook.

If you send only:

WeatherPresentation.pptx

to another user, that user may not have access to:

WeatherForecast.xlsx

and the linked chart may not be refreshable.

If the recipient needs to update the chart, make sure the Excel workbook is also available from an accessible location.

If the recipient only needs to view the current chart, consider breaking the link or pasting a static copy before distribution.

What happens if the Excel workbook moves?

If the Excel source file is moved or renamed, PowerPoint may display a broken-link error.

Microsoft PowerPoint provides tools to update the source of an external link.

In PowerPoint desktop, you can use:

File → Info → Edit Links to Files

where available, and then choose:

Change Source

to point PowerPoint to the new Excel workbook.

Microsoft also allows a link to be broken, which converts the linked content into a static embedded copy.

PowerPoint desktop versus PowerPoint for the web

Linked Excel files work best with the desktop version of PowerPoint.

PowerPoint for the web has more limited support for linking to local Excel files. Microsoft notes that linked Excel charts in PowerPoint for the web generally require the source to be available through a cloud or web-accessible location such as OneDrive.

If your workflow depends on local linked Excel files, use the desktop version of PowerPoint.

Should I use an embedded Power Query inside PowerPoint?

Older PowerPoint workflows sometimes created a chart directly in PowerPoint and then used the chart’s embedded Excel workbook to create a web query.

That approach can still work in some desktop Office configurations, but it has several disadvantages:

  • The data connection is hidden inside the presentation.
  • Troubleshooting Power Query is harder.
  • The workbook is less convenient to reuse.
  • API credentials are harder to manage.
  • Refresh behavior can differ between Office versions.
  • Moving the data work into Excel produces a clearer separation between data retrieval and presentation.

For most new integrations, create the weather query and chart in a normal Excel workbook and then link the resulting chart into PowerPoint.

Automatically refreshing the Excel query

Excel Power Query supports configurable refresh behavior.

Depending on your version of Excel and the data connection, query properties may allow you to refresh data:

  • Manually
  • When the workbook opens
  • At configured intervals

For presentations used regularly, a practical workflow is:

Open Excel workbook
        ↓
Refresh All
        ↓
Confirm chart
        ↓
Open PowerPoint
        ↓
Update Link / Refresh Data

This keeps the refresh process explicit and easier to troubleshoot.

Make a presentation self-contained

Sometimes you need to distribute a PowerPoint presentation without its Excel workbook.

In that case, you can:

  1. Refresh the weather data in Excel.
  2. Update the linked chart in PowerPoint.
  3. Break the link or paste a static version.

The chart will then remain visible even if the original workbook is unavailable.

The tradeoff is that the chart will no longer update automatically when the Excel data changes.

Use current conditions in PowerPoint

You can also build a presentation containing current weather.

Request:

include=current

The Timeline response includes:

currentConditions

which can contain fields such as:

temp
feelslike
humidity
windspeed
conditions

Excel Power Query can transform those values into a small table suitable for a dashboard slide.

For details, see How to Get Current Weather Conditions from the Weather API.

Use weather data for multiple locations

The same Excel workbook can retrieve weather for multiple locations.

For example:

London, UK
Paris, France
New York, NY
Tokyo, Japan

You can then create:

  • One chart per location
  • A comparison chart
  • A summary table
  • Multiple presentation slides

For Power Query examples using multiple locations, see Import Weather API JSON into Excel Using Power Query.

Common PowerPoint weather presentation ideas

Weather-enabled presentations can be useful for:

Operations

Display forecasts for operational locations.

Transportation

Show precipitation, wind, snow, or visibility forecasts.

Sales

Compare historical sales with weather conditions.

Agriculture

Display temperature, precipitation, solar, or growing-condition information.

Energy

Show weather variables used to explain or predict energy demand.

Events

Display forecast conditions for an outdoor event.

Executive reporting

Add weather context to business performance reports.

Troubleshooting

The chart does not update

First verify that:

  1. Excel has refreshed the Weather API data.
  2. The Excel chart reflects the new data.
  3. The Excel workbook has been saved.
  4. PowerPoint still has a valid link to the workbook.
  5. You have selected Update Link or Refresh Data where required.

Check whether the Excel workbook:

  • Was moved
  • Was renamed
  • Was deleted
  • Is on an unavailable network drive
  • Is in a cloud location you cannot access

Use PowerPoint’s link-management tools to change the source.

Excel cannot retrieve the weather data

Check:

  • API key
  • Location
  • Weather API URL
  • Dates
  • Power Query credentials
  • HTTP error message
  • Account usage limits

For API errors, see Weather API HTTP Error Codes.

The chart contains old weather

Refresh the Excel query first.

The PowerPoint chart can only display the weather currently present in its linked Excel source.

Summary

The recommended way to add refreshable Visual Crossing weather data to Microsoft PowerPoint is:

  1. Retrieve weather data in Excel using Power Query.
  2. Create a chart in Excel.
  3. Save the workbook.
  4. Copy the chart.
  5. Paste it into PowerPoint using a Link Data option.
  6. Refresh the weather data in Excel when needed.
  7. Update the linked chart in PowerPoint.

This approach keeps weather retrieval and transformation in Excel while using PowerPoint for presentation and visualization.

It also makes it easier to reuse the same weather dataset in multiple charts, slides, and reports.

For a complete Excel data-loading walkthrough, see Import Weather API JSON into Excel Using Power Query.

For complete Weather API details, see the Timeline Weather API documentation.