"Footer" in Excel Chart

Caliche

Active Member
Joined
Mar 26, 2002
Messages
339
What is the best way to have an embeeded chart "footer" with the file's path the chart is in ?. I want to have this in my chart as a reference when I copy my chart to Power Point.

I suppose this must be done with VBA code.

Thanks a lot for your ideas.

Caliche
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi Caliche,

How to do this depends on whether you want the chart footer to be visible on the PowerPoint slide. If not, then using VBA to automatically add the path to the chart's footer is the way to go, since you can then paste the chart as an embedded Excel object and the header/footer information is embedded as part of the Excel object.

But if you want the "footer" to be visible on the PowerPoint slide, then you must simulate a footer using a drawing object (Textbox Shape) which VBA code can automatically insert the path into. This has the advantage that the chart can be pasted as an embedded object, a picture object, or as an enhanced metafile (which gives the best graphic quality and the smallest embedded object file size). The latter two object types require using Paste Special.

Let us know whether you want a visible or invisible footer, and we'll help you with the VBA code.

Damon
 

Caliche

Active Member
Joined
Mar 26, 2002
Messages
339
Damon Ostrander said:
Let us know whether you want a visible or invisible footer, and we'll help you with the VBA code.

Damon

Thanks Damon for your answer: I want the Excel chart Footer to be visible when I copy it to the PP slide.

Thanks again for your help.

Caliche
 

Watch MrExcel Video

Forum statistics

Threads
1,118,082
Messages
5,570,095
Members
412,311
Latest member
Mozz
Top