Excel 2007 PivotTable and Chart

M

Michael

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTable and Chart 0
Create a chart from a table in word thats dynamic 0
Linking PivotTable Fields - Excel 2007 1
Link PivotChart to PivotTable, whilst hiding fields 0
roblems with creating my pivottable because of the way my data is structured 0
Creating Network Diagram using a Chart SW integration 0
Pivot Table operation is different 1
Placing a Pivottable in A1 0

Top