line chart

[Randy K.]

I have a temp table that gets built each time a report is run to use as the
record source of a chart on another unbound report. The table contains
char(),int,int datatypes and the record source for the chart select the
char() & int and sorts (but does not include) the 2nd int column so I end
with something that may resemble this as a record source for the chart:

1/2004 1500
2/2004 1275
3/2004 1700
4/2004 900
etc.

I want to create a line chart that will basically show the use the date
field (char()) as the x axis and the values as the y axis and end up showing
one line with the values marked at the different date points (value over
time). When I select a line chart, I end with the correct y axis, but the x
axis gets messed up and all the values (records) are plotted to multiple
lines but all at one spot on the x axis.

This is a very simple chart is excel and I need to reproduce it in access so
it can be run real-time based on the values in a query. I have checked for
help and/or samples on the web and don't see any that are for line charts.

Any help is appreciated.
TIA,
Randy

 

[Randy K.]

It appears exactly as expected, 2 columns, varying rows with date in one
field and value in second field. Any ideas why the chart wants to display
all values in a single vertical line instead of line over time?

TIA,
Randy

 

[Duane Hookom]

Check the Row Source (query) of the chart control. Make sure it displays the
correct values.

 

[Duane Hookom]

Do what I would do, open the graph object and play with various settings
such as plotting horizontal or vertical or whatever.