Resize the Data table in the Pivot chart.

G

grishma.bhaskaran

I have a prepared a chart where there are count of 15-20 items
displayed in the chart and I have also shown the data table for the
same. But the data table do not fit in all teh 15-20 items.
Could some one help in with a method where I can fit all the data in
the data table along with the chart.

Earliest help much appreciate.

Regars
GS
 
S

Shane Devenshire

Hi,

You have very little control of data tables - your only solutions are to
make the font size smaller, and to enlarge the entire chart. I recommend you
place the equivalent of a data table below the chart, in the spreadsheet,
where you have 100% control.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Pivot Table Chart - Group Totals 1
Pivot chart 1
Pivot Chart Data Table 1
How to add colum totals to a pivot chart data table 1
how to retain data in table only but do not graph of that data 1
Pivot Table Data 2
Excel 2007 Pivot charts, any way to display filters on the chart? 1
Pivot table chart problem, How to show different subtotal levels 2

Top