View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default Excel 2007 PivotTable and Chart

Hi,

I have a PivotTable and below it, a Chart. The height of the PivotTable is
dynamic, depending on the data I filter on.

The problem I have is that if I put the chart too high up, it can happen
that the PivotTable will be displayed behind the chart (depending on what I
filter on). Is there a way to put the chart just below the PivotTable, and
having it move down automatically if the PivotTable need more rows? (or move
up if the PivotTable needs less rows)

Thanks.