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

How do I manipulate MSGraph-objects?

P: n/a
Hi!

I have found the MSGraph object very easy to use in Access if you use it in
a straightforward manner. Just by changing the object rowsource ( I use
sql), the graph changes accordingly.

However, the time is now to go one step further.
I use a line-graph based on data from Crosstab-queries to show the sales for
each salesman, each month.
The problem is that the Boss liked it so much that he wants to add in
totals, last year results and the budget-figures.
How do I include results from four different SELECT-statements in one Graph?

I know there is several different ways to solve this, but my instinct (or
stupidity??) tell me that the easyest way is to add three more rows to the
rowsource og the graph..

Example of underlaying table
Item January February ....
Jim 100 103
John 93 110
Total 193 213
Last Year 204 195
Budget 200 210

The first three rows comes straight out of the crosstab query. How do I
insert the last three?
Is it possible to use methods and properies for the MSGraph-object, or do I
have to define a new table/query, push data into it and then set ther
table/query as the graphs rowsource?

I basicly need to know everyting, ie: What syntax do I use to manipulate
MSGraph's properties and methods from Access

I hope anyone can help me here.
Thanks

André
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Andre Kristoffersen" <an*****************@c2i.net> wrote in message
news:Ue*******************@news.telia.no...
Hi!

I have found the MSGraph object very easy to use in Access if you use it in a straightforward manner. Just by changing the object rowsource ( I use
sql), the graph changes accordingly.

However, the time is now to go one step further.
I use a line-graph based on data from Crosstab-queries to show the sales for each salesman, each month.
The problem is that the Boss liked it so much that he wants to add in
totals, last year results and the budget-figures.
How do I include results from four different SELECT-statements in one Graph?
I know there is several different ways to solve this, but my instinct (or
stupidity??) tell me that the easyest way is to add three more rows to the
rowsource og the graph..

Example of underlaying table
Item January February ....
Jim 100 103
John 93 110
Total 193 213
Last Year 204 195
Budget 200 210

The first three rows comes straight out of the crosstab query. How do I
insert the last three?
Is it possible to use methods and properies for the MSGraph-object, or do I have to define a new table/query, push data into it and then set ther
table/query as the graphs rowsource?

I basicly need to know everyting, ie: What syntax do I use to manipulate
MSGraph's properties and methods from Access

I hope anyone can help me here.
Thanks

André

Probably the easiest way would be to output all your queries into a
temporary table and then base your graph on that.

I've built a graphing system that builds the graphs datasheet directly via
code and manipulates the graphs appearance.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.