Create a chart WITHOUT using tables or queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

noe1818 - 11 Jan 2008 21:41 GMT

I want to be able to create a chart from some total boxes on my report. The
totals are not stored in any table, but I want to create a chart from them.
The problem is that chart wizard only uses tables or queries to make it's
graphs. Any way to do this?

Reply to this Message

Douglas J. Steele - 11 Jan 2008 22:32 GMT

As far as I'm aware, there's no way using the built-in Graph objects.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I want to be able to create a chart from some total boxes on my report. The
> totals are not stored in any table, but I want to create a chart from
> them.
> The problem is that chart wizard only uses tables or queries to make it's
> graphs. Any way to do this?

Reply to this Message

DeltaTech - 13 Jan 2008 19:05 GMT

Hi

A chart is a report.
Therefore the information shown is based on a Table or Query.

Try calculate your totals inside your report query
Then use the totals from the query to create your chart.

Have Fun

DeltaTech

Reply to this Message

noe1818 - 14 Jan 2008 15:12 GMT

Maybe you can help me. I have a series of option groups. The choices are
given values, but some have the same value (0). So I did a "IIF" statement,
saying that if the choice = some value, assign it a 0, otherwise give it the
chosen value. I had these statements in unbound text boxes so I could do a
total from these text boxes. Totals came from groups of the choices. I wanted
to create a graph from the total boxes. How could I have put these in a table
or query using the IFF statement and then created a graph from them?

>Hi
>
[quoted text clipped - 13 lines]
>> The problem is that chart wizard only uses tables or queries to make it's
>> graphs. Any way to do this?

Reply to this Message