Charting
 

Not sure if this post belongs in an Access newsgroup, or this one, since the
VBA code originates from an Access form.... My question involves charting
exported data to an Excel worksheet, so I'll try here first.

As stated, I have an Access form that exports to an Excel workbook. From
Access, I chart the exported data via the ChartWizard method. The
ChartWizard does not make the correct assumption for my X and Y axis, and I
cannot seem to find a way to set these manually.

I have also found a bit of a "side" problem, in so much as saving the
exported workbook and trying the chart wizard manually from Excel, my
numbers are graphed as "0". Formatting these columns from "General" to
"Number" does not seem to make a difference. Only when I retype the number
in the cell does the graph respond.

Any help is greatly appreciated!

T. Street