I have created a graph object in a form that works great, except for when I
try to display data values. The graph is showing the all numbers in a
standard format. (i.e. no $,%. etc...) I can manually change this in the
datasheet, but the next time the graph is updated, it deafaults back to the
standard format. The query this chart is based on is formated to my desired
format, but the graph apparetnly doesn't refer to that. Any ideas?
--
Neil

Try exporting the data to an Excel range and creating the chart in Excel. If
you have a single set of values that you use as data points, you can use
Excel automation directly. Here's a sample:

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

If the amount of your data cannot be reduced to a single row, try using the
OutputTo Method to an Excel range. Use a summary row in Excel to provide the
data for your chart.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"nFaux" <(E-Mail Removed)> wrote in message
news:CD5877C6-9EF1-4380-9F9D-(E-Mail Removed)...
>I have created a graph object in a form that works great, except for when I
> try to display data values. The graph is showing the all numbers in a
> standard format. (i.e. no $,%. etc...) I can manually change this in the
> datasheet, but the next time the graph is updated, it deafaults back to
> the
> standard format. The query this chart is based on is formated to my
> desired
> format, but the graph apparetnly doesn't refer to that. Any ideas?
> --
> Neil