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

MS Graph Completely Useless in A97?

P: n/a
Is MS Graph really completely useless in Access 97?

I uninstalled and re-installed to get the Office 97 version of MS
Graph, but I see no way whatsoever to insert dynamic data into the
chart. The wizard has got to be the worst wizard I've seen in
Access, because it assumes way, way too much about what you want.

And then when you click FINISHED, what you get has absolutely
nothing to do with what you chose for the graph.

Is my system setup wrong or something?

Or is it just a big steaming pile?

Back in Access 2, I had no trouble creating nice graphs.

Is there an alternative? Automating Excel, for instance? I can
certainly create the graph I need there.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Well, you don't say much about what you are doing. I did not have
difficulties with it, although it is not always intuitive.

Generally you put the control on a form. You send data to it by assigning
the RowSource to an Access query or SQL, and this query can be filtered to
match other selection fields on the current row of the form. Is this how you
are using it?

You may want to verify that the Access control properties for the chart have
Enabled true and Locked false, at least in the beginning. In form design
view, you double-click the graph control to get its design view. You can
right-click on just about anything in the chart to set its properties in
design view.

MS Graph has its own object model, and you can use autocomplete or the
object browser to learn about it. There have been many sample code snippets
in this newsgroup to set various properties.

Excel charts seem to have more options, but MS Graph has quite a few. As you
well know, Excel is harder to control, takes lots of memory, does not look
like part of your Access application, and requires your users to have a
working copy of Excel.

- Steve

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.90...
Is MS Graph really completely useless in Access 97?

I uninstalled and re-installed to get the Office 97 version of MS
Graph, but I see no way whatsoever to insert dynamic data into the
chart. The wizard has got to be the worst wizard I've seen in
Access, because it assumes way, way too much about what you want.

And then when you click FINISHED, what you get has absolutely
nothing to do with what you chose for the graph.

Is my system setup wrong or something?

Or is it just a big steaming pile?

Back in Access 2, I had no trouble creating nice graphs.

Is there an alternative? Automating Excel, for instance? I can
certainly create the graph I need there.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #2

P: n/a
"Stephen K. Young" <s k y @ stanleyassociates . com> wrote in
news:2j*************@uni-berlin.de:
Well, you don't say much about what you are doing. I did not have
difficulties with it, although it is not always intuitive.
I alluded to it. Turns out the solution was here:

http://support.microsoft.com/default...scid=kb;154454
Generally you put the control on a form. You send data to it by
assigning the RowSource to an Access query or SQL, and this query
can be filtered to match other selection fields on the current row
of the form. Is this how you are using it?
Well, I was using a fixed data source, a query that used a dialog
form to collect some dates for filtering.

But creating the graph was not displaying the correct data in
datasheet view, so I couldn't assign the correct columns to the
appropriate data series.

After jumping through the hoops described in the KB article, I was
able to get a workable graph, though it wasn't fun.
You may want to verify that the Access control properties for the
chart have Enabled true and Locked false, at least in the
beginning. In form design view, you double-click the graph control
to get its design view. You can right-click on just about anything
in the chart to set its properties in design view.

MS Graph has its own object model, and you can use autocomplete or
the object browser to learn about it. There have been many sample
code snippets in this newsgroup to set various properties.
Well, I got it to work by getting the data source into it in the
form version (as instructed), then copied and pasted it into the
report. Remember, this is an A97-specific problem.
Excel charts seem to have more options, but MS Graph has quite a
few. As you well know, Excel is harder to control, takes lots of
memory, does not look like part of your Access application, and
requires your users to have a working copy of Excel.


Well, I wanted to have dual axes, and thought MSGraph as implemented
in Access97 couldn't do that. Turns out I was wrong -- it can. Once
I had the right data in there, I also got the opportunity to choose
primary and secondary axes.

What a messed-up situation.

I'm glad I don't have to do it often.

Of course, now I have to figure out what the client has and see if
it works on their machines.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #3

P: n/a
> Turns out the solution was here:

http://support.microsoft.com/default...scid=kb;154454
Or, as I remember, you just shift to data view and type in
the sample data you wish to see.

(david)
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74... "Stephen K. Young" <s k y @ stanleyassociates . com> wrote in
news:2j*************@uni-berlin.de:
Well, you don't say much about what you are doing. I did not have
difficulties with it, although it is not always intuitive.


I alluded to it. Turns out the solution was here:

http://support.microsoft.com/default...scid=kb;154454
Generally you put the control on a form. You send data to it by
assigning the RowSource to an Access query or SQL, and this query
can be filtered to match other selection fields on the current row
of the form. Is this how you are using it?


Well, I was using a fixed data source, a query that used a dialog
form to collect some dates for filtering.

But creating the graph was not displaying the correct data in
datasheet view, so I couldn't assign the correct columns to the
appropriate data series.

After jumping through the hoops described in the KB article, I was
able to get a workable graph, though it wasn't fun.
You may want to verify that the Access control properties for the
chart have Enabled true and Locked false, at least in the
beginning. In form design view, you double-click the graph control
to get its design view. You can right-click on just about anything
in the chart to set its properties in design view.

MS Graph has its own object model, and you can use autocomplete or
the object browser to learn about it. There have been many sample
code snippets in this newsgroup to set various properties.


Well, I got it to work by getting the data source into it in the
form version (as instructed), then copied and pasted it into the
report. Remember, this is an A97-specific problem.
Excel charts seem to have more options, but MS Graph has quite a
few. As you well know, Excel is harder to control, takes lots of
memory, does not look like part of your Access application, and
requires your users to have a working copy of Excel.


Well, I wanted to have dual axes, and thought MSGraph as implemented
in Access97 couldn't do that. Turns out I was wrong -- it can. Once
I had the right data in there, I also got the opportunity to choose
primary and secondary axes.

What a messed-up situation.

I'm glad I don't have to do it often.

Of course, now I have to figure out what the client has and see if
it works on their machines.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #4

P: n/a
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:<40***********************@news.syd.swiftdsl. com.au>...
Turns out the solution was here:

http://support.microsoft.com/default...scid=kb;154454


Or, as I remember, you just shift to data view and type in
the sample data you wish to see.

(david)
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74...
"Stephen K. Young" <s k y @ stanleyassociates . com> wrote in
news:2j*************@uni-berlin.de:
Excel charts seem to have more options, but MS Graph has quite a
few. As you well know, Excel is harder to control, takes lots of
memory, does not look like part of your Access application, and
requires your users to have a working copy of Excel.


Well, I wanted to have dual axes, and thought MSGraph as implemented
in Access97 couldn't do that. Turns out I was wrong -- it can. Once
I had the right data in there, I also got the opportunity to choose
primary and secondary axes.

What a messed-up situation.

I'm glad I don't have to do it often.

Of course, now I have to figure out what the client has and see if
it works on their machines.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


I used Excel to obtain a graph for Access97 once. I made a template
with a blank sheet, a summary sheet and a graph. Access filled in the
field values on the first sheet, replaced the summary percentage
values on the second sheet and let the pie chart on the third sheet
use the new summary percentages. Now that I have Access creating pdf
files I should a write a set of graphical interface functions that
would allow me to create graphs that can be viewed with Acrobat.

James A. Fortune
Nov 13 '05 #5

P: n/a
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in
news:40***********************@news.syd.swiftdsl.c om.au:
Turns out the solution was here:

http://support.microsoft.com/default...scid=kb;154454


Or, as I remember, you just shift to data view and type in
the sample data you wish to see.


Well, I did past correct data into, but I couldn't see that it would
update. In retrospect perhaps it would have worked, but I wasn't
going to spend all that time setting up a complicated graph to have
it not work.

It's really quite messy bug, rather unbelievable that such a thing
would have shipped with the product.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6

P: n/a
Bug ??? I didn't find any bug ??? My report graph showed
the bound data in print and view mode. In design mode it
showed the sample data. I did have to save the report in
design mode to get the sample data to stick, but I had to
save the report in design mode when I was designing anyway,
so it didn't seem to me that there was a bug ???

My report data depended on user input, so it was really
helpful having sample data that was usable in design mode.

Still, I can see that in some other cases, it might be
useful (especially for beginners) to have the graph come
up with live data while the report was in design mode.

(david)

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@24.168.1 28.74...
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in
news:40***********************@news.syd.swiftdsl.c om.au:
Turns out the solution was here:

http://support.microsoft.com/default...scid=kb;154454


Or, as I remember, you just shift to data view and type in
the sample data you wish to see.


Well, I did past correct data into, but I couldn't see that it would
update. In retrospect perhaps it would have worked, but I wasn't
going to spend all that time setting up a complicated graph to have
it not work.

It's really quite messy bug, rather unbelievable that such a thing
would have shipped with the product.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.