Getting Pivotcharts into Reports

[fenfool]

I'm working in Access 2010, and used a crosstab query to make a pivotchart. It's a pretty simple bar chart. The question is that now that I've made this chart, how do I use it? I can't seem to figure out how to put it into a report...I made a report based on the crosstab query data, but it ONLY shows the data, not the chart. I know this HAS to be something simple that I'm missing, but I've been searching throgh boards and the web, and can't seem to figure out what it is I'm missing. Any help is appreciated!

 

[MarkK]

I've posted some code for how to do this here, but it presumes your chart is on a form.
Maybe this gets you a little closer to your goal?
Mark

 

[fenfool]

Well, this would bring the question of how to get it to a form...I'm kind of a newbie. There HAS to be a relatively simple way to do this, the charting feature in the queries is all nice and pretty, I can't belive there is no easy way to actually apply this to a report...

 

[MarkK]

You can set your query as the RecordSource of a form, and then display the form in PivotChart view, and take the same steps there that you took in the query to display your chart. I believe that will get you pretty close.

 

[fenfool]

I'm getting there! I have it in a form, now I'll see if I can use your code to get it in a report. Slowwwwwly but surely getting there!