chart in a form

  • Thread starter Thread starter pat67
  • Start date Start date
P

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
 
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 -
Click to expand...

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
 
Back
Top