How to link graphs without changing formatting?
I have excel graphs I want to link to a powerpoint presentation and graphs in powerpoint where I want to link the data back to excel. In each case, the formatting is changing in the link.
1. When I try to change or resize the powerpoint slide after the link, the excel graph gets distorted.
2. The powerpoint slide formats are setup by a department and you cannot change them. When you link the data tables, they change. For example, the Y axis is set up with a month and number of incidents (eg, Oct 2). Even when I format this is in excel as a text field, powerpoint still reads it as a date. The format doesn't even stay consistent. One column heading reads as 02-Oct and the next reads Nov 08. I want to link the data and not change the powerpoint format.