Problem with chart in a form

[Guest]

I used the chart wizard to create a scatter chart in a form. However, instead
of the chart displaying one series with 8 data points I get a chart with 8
series each of only 1 data point. The X axis is also displaying a count of
the data points rather than the actual X values in the underlying query.

How do I change this so that i get a chart of 1 series with 8 points?

thanks,
Robbie

 

[Guest]

Charts are not easy to deal with. The way I have approached it is to open
the Access properties of the graph and manipulate the data source. They do
require some trial and error.

 

[Guest]

I tried redoing the RowSource to read...

SELECT [BalanceQuery].IntegerDate, [BalanceQuery].Balance
FROM [BalanceQuery];

and removed the GROUP BY part but it still does the same thing.

It all seems a bit haphazard!!

 

[Guest]

I have a bar chart in a database which has values on the y-axis and date
along the x-axis. The bars are broken down by department

In the cross-tab:

the row heading is the x-axis
the column heading is the department (there is more than one)
the value is the y-axis.

What is the data you are using?

--

The 11th day of every month:

http://truthaction.org/forum/index.php

I tried redoing the RowSource to read...

SELECT [BalanceQuery].IntegerDate, [BalanceQuery].Balance
FROM [BalanceQuery];

and removed the GROUP BY part but it still does the same thing.

It all seems a bit haphazard!!

Charts are not easy to deal with. The way I have approached it is to open
the Access properties of the graph and manipulate the data source. They do
require some trial and error.

--

The 11th day of every month:

http://truthaction.org/forum/index.php