I have one doubt regarding creating charts in Excel and embedding them in PowerPoint.
Is it possible to create multiple charts in single excel file(in separate sheets) and embed them in powerpoint(as different OLE objects per chart)?
Or do we need to create separate excel files per chart?
How can we instruct PowerPoint to open a particular chart/sheet in the embedded excel when we click on chart image?
I mean when we click on Chart1, I want to open the worksheet which has Chart1 and when we click on Chart2, I want to open Chart2 sheet. Is it possible?
In short, ABC.xls contains 3 sheets(named ChartSheet1, ChartSheet2, ChartSheet3) having charts. I want to add 3 slides in to XYZ.ppt, where in first slide, I want to embed one chart from ChartSheet1, second slide OLE object should point to chart in ChartSheet2, and so on.