chart in a form

[pat67]

Hi. Having never used a chart in a form before I am having some
difficulty. First off when i use the data from the table it is only
showing 1 series and not more. I can start there if someone can help
me on this. Thanks

 

[pat67]

Even though Excel and Access use the same charting engine, the best
implementation is in Excel. For that reason, when using charting, I always
use Excel. Gather your data to be used in a query and export it to a range
in an Excel spreadsheet. Check the help files for OutputTo and
TransferSpreadsheet, for complete instructions and look at:

http://www.mvps.org/access/modules/mdl0006.htm

and:

http://www.mvps.org/access/modules/mdl0035.htm

for some sample code using automation. If you need more help post back.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://www.mvps.org/access
Co-author: "Access Solutions", published by Wiley






- Show quoted text -

That's all fine ecept i want the chart in a form in access. i fixed
the first issue. now the issue is that i have a table with month and
year and a data. The issue is that i have a "target" value at the end
and the name "target" as a month data. When the chart runs it puts the
target value first and blanks it out. How can i adjust it? i tried
going into the chart data and moving teh values but when i do that it
just reverts back