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??
|