access 2007, in design view of a report i added a chart, but it isnt able to
cope with the amount of data so throws up a few errors then the chart is
blank, so i managed to create a pivot chart and added the form to my report,
this seems to work much better except in print preview, the pivot chart in
the report shows boxes with drop filter fields here etc and horrible gray
boxes for date and sums. can these pivot charts be altered to look better??

i managed to find the solution i was looking for not long after raising this
post, i needed to edit the show/hide properties for the pivot chart. looks
great now..

"StuJol" wrote:

> access 2007, in design view of a report i added a chart, but it isnt able to
> cope with the amount of data so throws up a few errors then the chart is
> blank, so i managed to create a pivot chart and added the form to my report,
> this seems to work much better except in print preview, the pivot chart in
> the report shows boxes with drop filter fields here etc and horrible gray
> boxes for date and sums. can these pivot charts be altered to look better??