Chart based on values from a function

[BerkshireGuy]

I have two functions that calculate two numbers based on based in
parameters. So, the functions return a value.

Is there a way to create a chart based on values from a function?

The only other thing I can think of is have a make table query call the
fuctions and then base the chart from that?

Thanks
Brian

[BerkshireGuy]

Also, what would be the best way to display these values in charts?

Looking to show the difference between active and participating
agencies. The number is really close, so pie chart doesnt look right.
82 out of 88
BerkshireGuy wrote:

I have two functions that calculate two numbers based on based in
parameters. So, the functions return a value.

Is there a way to create a chart based on values from a function?

The only other thing I can think of is have a make table query call the
fuctions and then base the chart from that?

Thanks
Brian

[BerkshireGuy]

Also, what would be the best way to display these values in charts?

Looking to show the difference between active and participating
agencies. The number is really close, so pie chart doesnt look right.
82 out of 88
BerkshireGuy wrote:

I have two functions that calculate two numbers based on based in
parameters. So, the functions return a value.

Is there a way to create a chart based on values from a function?

The only other thing I can think of is have a make table query call the
fuctions and then base the chart from that?

Thanks
Brian

[Tim Marshall]

BerkshireGuy wrote:

I have two functions that calculate two numbers based on based in
parameters. So, the functions return a value.

Is there a way to create a chart based on values from a function?

Just make a query using the function(s) and set the query as the chart's
row source.

If you don't think a pie portrays what you want (it's ideal, IMO, for
the two values you describe) then I'd recommend using a column chart.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[BerkshireGuy]

Hey Tim:

I tried that and it wouldn't let me. My guess is because I hadnt
specified a table, which I dont need in this instance. That is why I
thought Maketable query - which can be launch when opening the chart?

Thanks,
Brian

Tim Marshall wrote:

BerkshireGuy wrote:

I have two functions that calculate two numbers based on based in
parameters. So, the functions return a value.

Is there a way to create a chart based on values from a function?

Just make a query using the function(s) and set the query as the chart's
row source.

If you don't think a pie portrays what you want (it's ideal, IMO, for
the two values you describe) then I'd recommend using a column chart.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim Marshall]

BerkshireGuy wrote:

Hey Tim:

I tried that and it wouldn't let me. My guess is because I hadnt
specified a table, which I dont need in this instance. That is why I
thought Maketable query - which can be launch when opening the chart?

A pointless waste of resources. There's no reason why a query won't
work. I have several apps which construct a background query based on
criteria choices made by the user and turn this into a chart.

Check to make sure your query runs properly on its own. Then run the
chart wizard against the query in question.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me