By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Chart based on values from a function

P: n/a
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

Dec 20 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Dec 20 '06 #2

P: n/a
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
Dec 20 '06 #3

P: n/a
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
Dec 21 '06 #4

P: n/a
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
Dec 21 '06 #5

P: n/a
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
Dec 22 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.