line chart

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

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" wrote in message
...
Check the Row Source (query) of the chart control. Make sure it displays
the
correct values.

--
Duane Hookom
MS Access MVP


"Randy K." wrote in message
...
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

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

--
Duane Hookom
MS Access MVP


"Randy K." wrote in message
...
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

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

--
Duane Hookom
MS Access MVP


"Randy K." wrote in message
...
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" wrote in message
...
Check the Row Source (query) of the chart control. Make sure it displays
the
correct values.

--
Duane Hookom
MS Access MVP


"Randy K." wrote in message
...
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