Software

Ask something
Discussion Locked

Linking

0 helpful
4 replies

by b kalaus

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to link a large excel spreadsheet with graphs into powerpoint. I want the graphs to update automatically to the next month and drop the previous. I am also looking to learn how I can include 2 seperate data ranges (axis to show month) in the source date.

I currently go into the graph and change the source data but after 300 charts it becomes very tedious.

4 replies

by dklippert

I don?t have time to lay out the details right now, but I?m looking at something along the lines of this article:

(Type the Q number into the ?For solutions containing...? box at support.microsoft.com)

Using Defined Names to Automatically Update a Chart Range

Q183446

With named ranges, you should be able to programmatically choose a month and have the charts update automatically. Let me know if you need more examples.
BTW take a look at www.j-walk. Com for some charting tricks.

by dklippert

You don't mention which verson of Excel, but how about a Pivot table?
The data can be easily manipulated to show the latest "quarter". Create a graph from the table (2000 and XP make it easy).
If you copy the chart and Paste Special>link to a PP slide, the graph will automatically adjust.

This discussion is closed to new replies.