basic chart in form

[vf-guy]

Hello,

I've been trying to put a horizontal bar chart on a form, where the underlying data from the query is a single list of numbers.

For example: 3, 9, 7, 7, 2, 5

I want the chart to return the list of numbers without the default action of counting the instances these numbers. I want, in this case, 6 horizontal bars sorted largest to smallest.

9 ---------


7 -------
7 -------
5 -----
3 ---
2 --

The chart, by default will show the COUNT of each number, but I want it to just show each value independently.

Any thoughts on how I can accomplish this?

Thanks.

[June7]

I analyze chart issues best when I can work with data. If you want to provide, follow instructions at bottom of my post.

However, I did a quick test with the data you posted. I built a table with 6 records and two fields: ID, Data.

I created a bar chart on form, just accept the defaults from wizard. Then change the RowSource to something like: SELECT ID, Data FROM Table1;

[vf-guy]

Hi, thank you for your reply.

I can do it easily with a table, just not with a query that only has one column of results.

Right now I'm trying to do an update query to put the results in a temporary table and create the graph based off the table.

Thanks.

[June7]

Why would query have only one column? Again, if you want to provide db, will look at.