Data format in graphs

[Guest]

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?

 

[Arvin Meyer [MVP]]

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.