#1
|
|||
|
|||
PowerPoint 2013: problems with links from Excel charts
I've used PPT 2013 for reporting for a few years, and had a similar process with previous versions. This problem has only just started about 4 weeks ago. I'll simplify this as much as I can.
Basic process is to create a chart in Excel 2013, using data within a charts workbook. Do as much formatting as makes sense, but Powerpoint doesn't always use the formatting that's brought across and there are usually some tweaks needed. I 'copy' the chart in Excel, and paste into the PPT slide using "Keep Source Formatting and Link Data". Repeat for as many different slides as needed. The Excel workbook is in the same directory as the PPT file. To send to the client, I break the links using Edit Links (manually because the FixLinks tool won't break these kinds of links and I haven't found another tool - I'm not good with VB), then save the PPT file with a different name so that I can distinguish internal and client versions. This process has worked pretty well for several years. There have been occasional glitches when the PPT has somehow got charts messed up, but I've usually found that there was a mistake in following the process, or that redoing a couple of slides fixes the issue. But with this report, the charts for several of the slides get messed up, with subsequent slides that are based on the same original data - but use different tabs in Excel with copies of data - looking somewhat like the first. After the links were broken, and when I had closed Excel and PPT and then reopened PPT. So if the first chart showed bars for A1/A2/A3 and the next slide used B1/B2/B3, the problem would be that the next slide looked as though it was showing A1/A2/A3. I found a couple of threads that mentioned problems with PPT 2013 and/or PPT 2016 that looks like same issue - when duplicating slides with charts in the data gets messed up. The symptoms weren't exactly the same, but similar enough to make me revise the process. There's a video at https://www.youtube.com/watch?v=u14zxHTjzOs I've been asking myself what's changed and what's stayed the same since this was working OK.
I'm sorry for the long message, and would appreciate any insights and advice. Thanks Mike |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create Several PowerPoint Charts From One Embedded Excel worksheet | Galapagos15 | PowerPoint | 0 | 10-30-2015 06:19 AM |
Charts automatically being created in Excel 2013 | a1dreams | Excel | 0 | 01-28-2015 12:11 AM |
Charts - formatting dates in a data table - Excel 2013 | IanGUK1 | Excel | 0 | 12-04-2014 01:44 AM |
Faulty alignment of charts linked from excel to powerpoint | Reem | PowerPoint | 0 | 05-25-2012 05:24 AM |
Turning off automatic links to Excel charts | Erdvige | PowerPoint | 4 | 04-26-2012 09:30 AM |