I have a chart in a report that is based on a query. When I view the chart in the layout preview it looks as I expect it. When I view the design view, the chart is in East, West, and North.

Also, I need to change the chart so that only the Top 10 categories are included.

I was able to do this in the Pivot Chart View in the query but not able to export the chart to the report.

Any help/suggestions?