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

On Aug 7, 8:29*pm, "Arvin Meyer" <arv...@invalid.org> wrote:
> 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
>
> "pat67" <pbus...@comcast.net> wrote in message
>
> news:e2838317-eef8-48b9-8011-(E-Mail Removed)...
>
>
>
> > 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- Hide quoted text -
>
> - 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