Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to display an image always at the bottom of the Pivot Table in Excel? Basically I am wondering if there is a way to create an image 'footer' for a pivot table.

share|improve this question
up vote 1 down vote accepted

You can combine textboxes, inserting images and formatting as you like. Make sure it is a width and height that should match your pivot table. It can also be JUST an image. My example uses two images.

If you ever alter the grouped textbox size or anything about it, the name of it changes, so Determine the current grouped textbox name and change it to something consistent

enter image description here <<< >>>enter image description here

Sub rename_afoot()
    ActiveSheet.Shapes("Group 78").Name = "afoot"
End Sub

So now there is a known name for the textbox

enter image description here

My sample pivot table has the datasource as a defined name in the workbook. Any changes that expand the data change the size of the pivot table range.

Sub addfooter()
Dim LastRow
    LastRow = Sheet1.Range("h" & Rows.Count).End(xlUp).Row
Range("H" & LastRow + 1).Select
Range("H" & LastRow + 1).Select
End Sub

enter image description here

This moves the textbox to the cell below the pivot table. This is definitely not perfect, but you might be able to adapt the idea. If the data expands or contracts the width, the size will not match, but someone may offer an answer to that.

share|improve this answer
thank you for such a detailed answer! – Alex N. Jan 25 '13 at 18:40
@AlexN. hope it will be adaptable to what you want. good luck – datatoo Jan 25 '13 at 21:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .