434,828 Members | 2,241 Online
Need help? Post your question and get tips & solutions from a community of 434,828 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
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.