Automatic updating graphs in excel

(I do not manually enter the data, it is a formula that I do not wish to delete.) I know I can manually move the data that the line is pulling to make it stop on the last month, but I have a graph for 36 different departments and that's a pain to have to manually adjust 36 graphs each month.Is there a way to tell the line to stop if there is no data? Hey everyone, I'm really hoping someone can help me with this...

When I work on the copied region, I find it a cumbersome task to go through each charts source data and change the cell references to the different region.

Essentially I am doing a trending analysis for each region, with a region having its own sheet with 5 charts per sheet.

Is there a tricky way to get all three on one graph?

I know I could split on two graphs, so that's my backup plan.

Hi there, I have a PPT deck with roughly 60 slides that needs updating once a month.

Each slide has a single enhanced metafile picture copied from an Excel deck, where worksheet 1 is the content for slide 1 of the deck.

For example: If data contains 06/01/2011 in cell A1, then data needs to be pasted to "Jun" worksheet within the same workbook. I just thought that MAYBE having a big button in their face will remind them.

Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins??? but a refresh so the screen actually updates in front of you.

Thanks, Dave Okay, so I tried (for hours) to find a solution to this and have finally gotten frustrated to the point where i think asking here will be my best bet.

Basically I want to export data from excel worksheets to various places on a word document I had. I basically have 1 constant worksheet that contains all my affiliates info (Name, Address etc), which i'd like to use to populate some bookmarks in my word template, and then i have another worksheet for the previous month, indicating sales etc for that affiliate. Matt Hello, I am pretty new to excel programming/messing around so I'll refer to those who are much wiser than I am.

I need the cell to keep in the cell the date of the day when I filled in the content of cell C90 and do not updated it every time i open the document to the actual date.. The problem is that when it gets to the last month, and there is not yet data for future months, the line goes down to Zero (leavin this big diagonal line that makes the data look funny).

Tags: , ,