Creating Custom Charts in Access

[dondark]

Hi,

I have a query. I am trying to run a report on this query that would create a chart summarizing the data. Access has the chart wizard that helps you, but you cannot format or change any aspect of the chart.

Is there any way I can do this? When looking atht e design of the report, I can see the terms OLE and MSGraph.Chart.8, but I don't really know anything about these codings.

Any helps?

Thanks,
Kevin

[OBP]

If you do not get an answer to this you can link an Excel spreadsheet directly to the Query and graph it in Excel.

[dondark]

But I want the chart to appear as part of a form or report in excel. Is there any way to do this?

[OBP]

You can change and format the Chart that the wizard has created, to do so right click on the Chart and select "Open" this will open the Chart in Microsoft Graph and is fairly straightforward to use.
The other option that I offered you using Excel for the Graphs can also be used in a report. To "Imbed" the Excel graph in the report click on the graph and select "copy" then open your report and select Paste Special - Link. this will copy your graph in to the report and it will be "live linked" to the excel graph thus showing any changes made to the Excel graph. The only downsides to this method is that you have to "size" the graph in Excel to fit the report in Access, once in Access you cannot simply adjust it's size, the other downside is that you may have to open Excel to update the data series when the data is changed in Access.