Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



Auto Updating Charts In Word Linked To Excel

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

The title pretty much summed it up. I have some charts copied into a word file. The charts are linked to the original charts in an excel file. Ideally I would love these charts to auto update whenever there is new data in the excel sheet. I will have a few of these charts in the word file and then a whole bunch of summaries below them explaining the weekly data. So far the closest I have gotten to this is having to just copy and paste the charts in the same Word file. Since there would be a couple of these charts in the Word file it doesn't seem like the easiest way to go. I would like to not have to use VB code but if it's the only way then I would give it a try. Thanks!

View Answers     

Similar Excel Tutorials

How to Make Macros Run A LOT Faster
Here is a very simple and easy-to-use tip to make all of your Excel macros run A LOT faster.  It is very simple and ...
How to use Vlookup Across Multiple Worksheets in Excel
This tutorial shows you how to use the Vlookup function across multiple worksheets within Excel.  This means that y ...
Linking Cells in Excel
In this tutorial I am going to cover how to link cells together. This is a useful feature of Excel as you can link ...
How to Resize Rows and Columns in Excel Quickly
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse ...

Helpful Excel Macros

Print All Charts That are in a Worksheet
- This macro will print all of the embedded charts which are on the current active worksheet. Each chart will be printed o
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Print all Embedded Charts in the Entire Workbook
- This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi

Similar Topics









Hi

I have a Word document that contains charts linked to an Excel sheet. I created the links by doing Paste Special > Paste Link.
Now when i go into the Word document the charts look like normal charts and the 'Update Link' option is not available. I re-pasted the charts as a link, saved the file and when i go back in the charts show no option to update link!

I use this method on a lot of reports i do and this is the first time i have know this to happen...any ideas??

Thanks

Hi,

I have a number of excel charts which need to be inserted into Word for my project. How can I make sure the sizing of all the charts will be consistent after importing them all?

that's what I do:

insert - object - create from file - Browse - chose my file - then use cropping to edit the picture -

is this the way? the problem here is I have so many charts which will be time consuming. Is this the simplest way? Since I have data in my excel sheet meaning that I need to hide them all for each sheet containing the chart.

Could you please help me in this?

Thanks heaps!


I have charts in XL2010 with rotated y-axis titles that I have pasted as OLE links into Word. I can resize the chart or update (F9) the chart when it is open and the formatting is maintained. However, when I reopen the file later the chart formatting is wrong sometimes- with the most obvious thing being that the y-axis title is no longer rotated (reads vertically from bottom to top with overlapping letters). Also, the chart lines are slightly bolder and slightly pixelated.

After pasting (paste special\linked\OLE) I am telling it to maintain formatting (with the \*MERGEFORMAT switch in the link) and I am turning off the auto update (via File\Edit Links\(select all)Manual). Save before exit.

I also have Excel tables, that I have linke to Word the same as I have done for the charts, that do not desplay the contents on reopen. I don't know if I'm making the same mistake with the tables as with the charts to lead to this...

What am I doing to cause this- or what can I change to maintain my formatting?

Thank you!


Hello,

I have a large workbook with over 35 tabs of data and charts. Most of the tabs are linked to two or three summary worksheets that are used as the source data to build Project tables and charts each month.

I have recently run into a problem where I am able to copy the first seven charts to my monthly report I make in Word, but I am not able to copy any of the last five charts. The copy function still works on the other charts and all the tables will let me copy and paste them to the report but these last five charts will not even copy.

Did I make these in a way that prevents me from copying them?

Paul (using Excel 2007 on WinXP Pro)


Hi -

I have a group of about 50 charts on one tab of a workbook called 'Charts'. These charts are pulling data from a different workbook - called 'Dashboard' which I open simultaneously. I have created a second tab with all of these charts in the same 'Charts' workbook - just copied one sheet to make a second sheet...but now on this second tab, I need the charts to link to a different tab in the 'Dashboard' file. The good think is, all the cells,rows and colums are the same in the tab I need to link to, I just need to change the sheet name that the charts are referencing from 'Sheet 1' to 'Sheet 2'. I tried to highlight the whole worksheet that the charts are on and do a find/replace...but that doesn't work. Is there a simple way to change the reference sheet name of all of these linked charts in one swoop?

Thank in advance for your help

Bfish44


every month I have to mail 24 charts to my collegue which arrived from differents file.The problem is that I have also to mail them all the 24 files.Is there easy way of just sending the the charts.Means macro or utility which looks in saved file and then copy the charts into one file which only has charts and not data.

Thanks


Hi,
I am copying excel charts into a word document, which has a specific layout for publicatiion. On several charts, parts are not showing in the word file e.g. top line on one chart and the far right on another. Any thoughts?
Many thanks,
Karen


Hi all,

I've got a complex workbook with lots of linked data - on one sheet there are 8 fan charts showing financial data.

When I paste the charts as pictures into Word 2007 , everything is fine. This is all on XP.

However, when I try to paste special them as linked Excel Chart objects, 4 of the charts paste in okay, but the others don't - with the ones that don't, it's _another_ chart from that worksheet that gets pasted instead.

I've never seen Excel do this -any ideas why it might be doing so?

Thanks in advance,

John


Hello, I am running into a problem when I create a PDF file out of many Excel Charts. The resulting PDF file is massive and I know that I can greatly reduce the PDF file size if I change all of the charts into pictures before printing.

I am wondering if it is possible to have a macro loop through all of the charts on a worksheet, copy them, and then paste them back in the exactly same place as a picture. I think it should be possible but I'm not sure how I would handle the names of the charts or paste them back down right where they are. Can someone tell me if this is possible and how it can be done, or if there's an alternative to converting all charts to pictures (external program). Thank you for the help!


I have an Excel file with pie charts in many worksheets. Many times when I open the file, the position of these charts is changed. They charts just seem to drift.

Is there a way I can lock the location of these charts to a certain cell?


Hi All,

I have written a little application that prints charts in a different workbook.
These charts get there source data from another workbook that is updated using the previous mentioned application.

What I would like to be able to do is to save the charts, once the file processing has been done i.e with filename as date for example. The trouble is that when I update the source data obviously all the charts change. What I want to do is after the file is saved, the source data becomes fixed and the charts do not update. So it would build up a sort of an archive.

Not sure if this is possible.


(Office 2003)
I know this is an Excel board, but I am hoping that the principles will transfer. I figured out how to do this in Excel VBA (updateLinks:=3) but Word doesn't seem to like that.

Basically, I've got a pile of about 100 .htm files in the same folder that need to be opened in Word to update the linked Excel Chart, then saved and closed. When I have the VBA just open the file, it always pops up a user prompt asking whether to update or not. I want this code to just do it.

I have found that I need to have the linked Excel files already open and charts activated in order for the updated chart not to be smushed. This may be because the .htm files are on a Sharepoint site and the .xls files are on a network drive.

Any help or pointers are greatly appreciated.


I have got an excel file with lots of data in and 3 of the tabs have 8 charts on each one. Without the charts the file size is 12meg and with the charts the file size is 27meg.

Is there any reason why charts can bump up the file size so much?

Thanks


Hundreds of threads regarding powerpoint-excel linking out here, but nowhere have I seen the answer to my question.

I am creating presentations in Powerpoint with charts from a standardized excel file. The charts are linked. Each excel file contains data from one company.

But when I receive a NEW excel file/company, I would like to simply copy my powerpoint presentation template and update the links to this new excel file. Since there are maybe 50 charts linked I do not want to update each link separately.

Does anyone have a clue?

Oh, and I use simple copy-paste to create the presentation today - no vba programs.


Hello!
I have a proposal document in Word that I am attempting to populate with various items from Excel sources. I already know how to create a new word document from Excel and then paste charts in it, but I'm trying to paste charts (and other items) into the middle of an existing word document. The code I'm using for creating a new document and pasting charts in works well, but each chart that's pasted in is added to the bottom of the document.
I thought that I could have a placeholder in the existing word document that I could search for using Excel VBA and then when I found it have Excel insert text, charts or tables at that point.
I have been able to insert text into a an existing document at the beginning or the end, just not in the middle.
Thank you in advance for any help!


When I copy the charts using copy and paste special in word (I pick Microsoft Office Excel Worksheet. The charts look fine when they are on screen and in print preview. However, when they are actually printed some of the charts loose there aspect and are printed partially (like left 1/3, 1/2, etc.) What causes this and how do you stop it. It is also somewhat random as it's not the same chart every time.


Hello,

I will attempt to describe my problem the best I can. Thank you in advance:

I have a series of charts (and the tables in which the data for the charts is stored) located in a worksheet. I copied and pasted each one of these charts next to its original. I then moved each one of the new, pasted charts into a single chart sheet at the end of the workbook. Is there a way, via macro or otherwise, to update the charts now located in chart sheet if any changes are made to the original charts?

Thanks,


I have an excel sheet with some charts. the data which are linked to the charts are on the same page.

But i want the charts to be updated when i want. ( as at now when the data is changed, excel will automatically update the charts)

How to ahieve this?




I've been using Office 2010 and have been copying excel charts into my word documents for some time. I particularly liked the functionality that allowed me to change the formatting of the chart in Word. Things like colours, size of fonts, etc. I've now moved to Office 365 where I find that I can no longer edit my chart's formatting in word. I've tried different linking and embedding options but so far the best solution I've come up with opens up my chart in Excel, and only allows editing in Excel.

I use both Excel and Word with the same chart data but previously I've been able to alter how the chart looks in Word. This allows the charts to appear to be different in each file but maintaining the same data (I hope that makes sense!)

It was easy in Office 2010 - Is this no longer possible in Office 365?

Thanks in advance
Colin

Hi,

I've set up couple customer user defined charts and link a macro to those charts but these charts weren't show up when i send the file to my co-worker. Is there way that i can share these charts? My macro kept prompting that these charts aren't exist in my co-worker's computer even though i saved the actual file on the shared server. Please help!

--Tony


Hi all. I have to do 3 set of charts monthly for 15 different depts. For example January has 3 sets of data and I have to create charts for 15 different depts. That's 45 charts in all for each month. I created the charts already. I have the data on one sheet and created the charts on different sheets and label it. My problem is I don't want to recreate the charts every month. If I change the data sheet or add data, the charts become distorted and I have to go through and select the data for each chart again. I want to have a copy of the charts from the prior month and just change the data sheet to reflect the current month and have the charts update automatically. How can I do this please?
Thanks


Hi,

I have a Source file that has lots of data and series (File 1). Now I want a separate file (File 2) to just have Charts that fetch data from the source file (File 1). The idea is to open the File 2 and order it to update everything in File 1 and show the updated charts.

I can write a Macro in file 2 to open and update Source file (file 1) it. The problem is how do i refer to the data of file 1 while plotting charts in file 2. My data length in source keeps increasing as more data is added, so I tried using Offset function (in file 2) to refer the source data. This works fine as long as both file 1 and file 2 are open, however the moment file 1 (source file) is closed this fails. I don't want the end user to worry about having opening or seeing the Source file (file 1), he/she should just open the File 2 and see everything.

How do i set dynamic data reference's to data in a different excel file???


Hi all,

I have a very strange problem. I have a number of charts set up on the one worksheet that reference to a data sheet by way of vlookup.

Anyway, 2 of my 4 charts are not updating when i change the product that im looking at. But when i go source data i can see that the cell references are correct and that the data has updated in the data sheet, it just hasnt shown up on the 2 charts (but the other 2 charts have updated)

So im at a loss as i cant understand why the data is not updating on the charts. Hope this makes sense.

Thanks in advance.

Cheers,


Hi there

I am looking at the possiblity of using linked charts in my power point document to the charts in excel. I know this can be done but the problem I have is that,

I want to be able open the poeerpoint file and update the links, and then I want to be able to distribute to other people without the other people being given the option of updating the links(i.e. as if the file they are receiving has no links).

Is there a way this can be done? Appreciate any pointers.

I am using Office 07

Thanks


Our office recently converted to Office 2007. I have 5 Excel file for each of our Divisions that are exactly alike except for the file name. Each of these files imports Division specific data from a master file. Once the data is imported I calculated several ratios and create historical bar charts of the ratios. Each chart is a separate sheet and has a unique name (ie. Cash, Free Cash Flow, Earnings etc.). Last time I had these files open the names on the charts were changed to generic chart names (i.e. Chart 1, Chart 2, Chart 3 etc.).

I know that the problem has something to do with all of the files being open at the same time because the charts were renamed sequentially in all of the files (the first file ended with Chart 5 and the next file started with Chart 6).

Each of the charts are linked to PowerPoint so as you can imagine all of my links are destroyed and I have to manually go back and change the name of each chart in each file (since there are 16 charts per file this is very time consuming).

Has anyone encountered this problem?

Why is this happening? And,

Is there a fix?