XY Scatter Chart

[ksbigfoot]

I am creating a chart inside of a microsoft access form.

I am trying to use the XY Scatter chart.
On the Y-axis, I have 2 columns of data listed based on 50 units.
On the X-axis, I have a timeline based on days.

When I press the 'Preview Chart' button when I am going through th
wizard and the chart and data look exactly like I need it to. Once
click the finish button, I get a totally different look. Has anyon
ran into this before?
Thank

 

[Debra Dalgleish]

Maybe the chart was created with series in rows, instead of columns. To
fix that:

Open the form in design view.
Double-click on the chart object.
In the Chart toolbar, click the 'By Column' button
Close and save the form.

If that doesn't solve the problem, you could ask your question in the
microsoft.public.access.forms newsgroup, and someone may be able to help.

 

[Jon Peltier]

When you get a preview of your chart, it's a little bitty image, and
perhaps not formatted the way a larger chart would be. For example, axis
tick spacings would vary dramatically, and this could create a large
difference in appearance.

Otherwise, follow Debra's advice, and ask someone who's had experience
with charts for Access forms.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[ksbigfoot]

Hi Debra & Jon,
Thanks Debra, the suggestion you posted fixed my problem.
Thanks again, ks