Graphing an Array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have stored a bunch of numbers in an array through VBA. I would like to
turn this array into a graph.

I have managed to save the array to a text file and import that file into
Excel from where I can graph it.

Unfortunately this is cumbersome - I would like to automate the process. Any
ideas how........

Thanks

Kenny
 
Kenny,

I suggest a different approach to what you are doing!

If you need to store the numbers permanently, they need to be stored in a table.
You can then use a query to return the specific numbers you need and easily
graph the numbers in Access.

If the numbers already exist in your database, you need to create a query that
returns the specific numbers you need and then again easily graph the numbers in
Access.
 
Kenny,

You don't need an extra field in your table for the running total. You can use a
query and calculate it on the fly and then graph the numbers returned by the
query.

Steve
PC Datasheet
 
Hi Steve,

I get what you are saying........I am just not sure I could generate such a
complex query.

It is not a running total as such........more of a moving total. The query
would have to add 1 days' figures to the total and then subtract another
days' figures(as it falls outside the period).

On top of this the query would have to examine every date, not just dates
for which there is data.

Is it possible to write the array to a table and then query and graph the
table?

Ok. Thanks for the help.

Kenny
 
Hi Steve,

I get what you are saying........I am just not sure I could generate such a
complex query.

It is not a running total as such........more of a moving total. The query
would have to add 1 days' figures to the total and then subtract another
days' figures(as it falls outside the period).

On top of this the query would have to examine every date, not just dates
for which there is data.

Is it possible to write the array to a table and then query and graph the
table?

Ok. Thanks for the help.

Kenny
 
Hi Steve,

I get what you are saying........I am just not sure I could generate such a
complex query.

It is not a running total as such........more of a moving total. The query
would have to add 1 days' figures to the total and then subtract another
days' figures(as it falls outside the period).

On top of this the query would have to examine every date, not just dates
for which there is data.

Is it possible to write the array to a table and then query and graph the
table?

Ok. Thanks for the help.

Kenny
 
Back
Top