Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 07-03-2019, 06:13 AM
Loftless Organist Loftless Organist is offline Charts in Templates Windows 10 Charts in Templates Office 2019
Charts in Templates
Join Date: Jul 2019
Posts: 1
Loftless Organist is on a distinguished road
Default Charts in Templates

I have set up quite a complicated report which includes line charts. For every new client I have, I copy this master Word doc to create a new report to which I can add bespoke text and amend the chart data.

When I copy the master report to create a new report, I simply select the graph and right click and select 'Edit Data'. I can then edit the data to make the graph specific to to that report. The problem is, if I then go to an old report which I produced some weeks ago, when I click to edit the chart, it pops up with the data from the last report I produced and the chart get changed accordingly (with the incorrect data).

I think I know why. When I created the master Word document, the chart is linked to a an Excel file somewhere on my computer. However, when I copy it, the copied Word doc is also linked to that same Excel file. Effectively, I end up with hundreds of reports all linked to the same Excel file.

How should I best set up my master Word doc so a new Excel file is created when I want to create a new report? Can anyone help please?
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
After updating linked excel charts in publisher, all charts are moved effinglife Publisher 0 05-23-2017 02:27 AM
Pie Charts EMS Excel 5 02-24-2017 04:25 PM
Charts in Templates How To Move Saved New Templates From My Documents To My Templates? woodbine Word 9 04-02-2015 10:28 AM
Office 2010 change location workgroup templates appear in from My Templates folder nickc Word 0 11-20-2013 03:38 AM
How to create charts and graphs as in templates. rohit007 PowerPoint 0 08-16-2012 12:18 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:39 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd. is not affiliated with Microsoft