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

Doesn't anyone care about scatter charts??

P: n/a
DFS
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response to
share.

Starting with the Chart Wizard, I can't get the Access scatter chart to
place the data points correctly, ie at the intersection of their XY
position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 11 '06 #1
Share this Question
Share on Google+
18 Replies


P: n/a
Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No one here
owes you a response. People provide responses to questions asked in an
appropriate manner as they see fit. This is a public forum where no one gets
paid. "

--

Terry Kreft
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response to
share.

Starting with the Chart Wizard, I can't get the Access scatter chart to
place the data points correctly, ie at the intersection of their XY
position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 11 '06 #2

P: n/a
DFS
Terry Kreft wrote:
Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No
one here owes you a response. People provide responses to questions
asked in an appropriate manner as they see fit. This is a public
forum where no one gets paid. "
Thanks for that. It's very informative.

Now what about the subject?

"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 11 '06 #3

P: n/a
DFS
And, FYI, I've posted many hundreds of 'MS Technical Support' responses to
cdma through the years, even though I wasn't getting paid and nobody was
owed a response.


Terry Kreft wrote:
Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No
one here owes you a response. People provide responses to questions
asked in an appropriate manner as they see fit. This is a public
forum where no one gets paid. "
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 11 '06 #4

P: n/a
DFS wrote:
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response to
share.

Starting with the Chart Wizard, I can't get the Access scatter chart to
place the data points correctly, ie at the intersection of their XY
position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks
You might find the solution in google by attempting another search...and
then poking thru the messages.

Goto http://groups.google.com

Then enter
scatter charts group:microsoft.public.*
in the search box. I wouldn't confine your search to just
Access...since Excel for example will use the same program...so the
above search checks out any microsoft.public group and perhaps you'll
spot something there, for Access or other MS programs, that has a solution.

Jul 11 '06 #5

P: n/a
DFS
salad wrote:
DFS wrote:
>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

You might find the solution in google by attempting another
search...and then poking thru the messages.

Goto http://groups.google.com

Then enter
scatter charts group:microsoft.public.*
in the search box. I wouldn't confine your search to just
Access...since Excel for example will use the same program...so the
above search checks out any microsoft.public group and perhaps you'll
spot something there, for Access or other MS programs, that has a
solution.
Thanks Salad. The problem is, the scatter charts in Excel work fine. I
just can't get them to work in Access.

Jul 11 '06 #6

P: n/a
On Tue, 11 Jul 2006 08:08:44 -0400, "DFS" <nospam@dfs_.comwrote:
>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response to
share.

Starting with the Chart Wizard, I can't get the Access scatter chart to
place the data points correctly, ie at the intersection of their XY
position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

The wizard is hard. It is easier in excel.
Remember that the spreadsheet origin of this package assumes that the query is a totals one though
you can use max or whatever.

Forget the wizard and set up the query yourself, an example of a straight x-y plot (in A97) is at
http://rapidshare.de/files/25552168/XYplot.zip.html

I would post it here - it's small enough - but only Lyle has dared to post a binary to this
newsgroup

Jul 11 '06 #7

P: n/a
Only hundreds?
--

Terry Kreft
"DFS" <nospam@dfs_.comwrote in message
news:X3*******************@bignews6.bellsouth.net. ..
And, FYI, I've posted many hundreds of 'MS Technical Support' responses to
cdma through the years, even though I wasn't getting paid and nobody was
owed a response.


Terry Kreft wrote:
Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No
one here owes you a response. People provide responses to questions
asked in an appropriate manner as they see fit. This is a public
forum where no one gets paid. "
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks


Jul 11 '06 #8

P: n/a
What about the subject?
--------------------------
Well, I can really only offer a personal opinion on this. Over the years
I've found that if I leave scatter charts alone then they return the
compliment, so it's not that I don't care about scatter charts it's more
that they and I respect each others space.
--

Terry Kreft
"DFS" <nospam@dfs_.comwrote in message
news:m2*******************@bignews6.bellsouth.net. ..
Terry Kreft wrote:
Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No
one here owes you a response. People provide responses to questions
asked in an appropriate manner as they see fit. This is a public
forum where no one gets paid. "

Thanks for that. It's very informative.

Now what about the subject?

"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks


Jul 11 '06 #9

P: n/a
DFS
Terry Kreft wrote:
Only hundreds?
Yep, I've been a slacker I'm afraid. Approaching 900 posts, including a few
pleas for help, going back to mid-2001.

That's about 180 per year, or one every other day overall for the 6-year
period. But during the periods when I do post regularly, it's sometimes up
to 8 or 10 per day.

All at true minimum wage.

"DFS" <nospam@dfs_.comwrote in message
news:X3*******************@bignews6.bellsouth.net. ..
>And, FYI, I've posted many hundreds of 'MS Technical Support'
responses to cdma through the years, even though I wasn't getting
paid and nobody was owed a response.


Terry Kreft wrote:
>>Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No
one here owes you a response. People provide responses to questions
asked in an appropriate manner as they see fit. This is a public
forum where no one gets paid. "
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.ne t...
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone
posts questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter
chart to place the data points correctly, ie at the intersection
of their XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 12 '06 #10

P: n/a
DFS
Terry Kreft wrote:
What about the subject?
--------------------------
Well, I can really only offer a personal opinion on this. Over the
years I've found that if I leave scatter charts alone then they
return the compliment, so it's not that I don't care about scatter
charts it's more that they and I respect each others space.
You gotta get with it, then. I have a client willing to pay big bucks to
give them a nice scatter chart onscreen and on a report. I ended up
hand-coding the thing, and it looks great - better than if I used the
built-in chart.

"DFS" <nospam@dfs_.comwrote in message
news:m2*******************@bignews6.bellsouth.net. ..
>Terry Kreft wrote:
>>Please see
http://www.mvps.org/access/netiquette.htm

particularly
"Do not confuse this newsgroup with Microsoft Technical Support. No
one here owes you a response. People provide responses to questions
asked in an appropriate manner as they see fit. This is a public
forum where no one gets paid. "

Thanks for that. It's very informative.

Now what about the subject?

>>"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.ne t...
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone
posts questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter
chart to place the data points correctly, ie at the intersection
of their XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 12 '06 #11

P: n/a
It's not a bug, it's just you.

Or rather, you and a fairly difficult user interface.

I don't think you'll get very far using the wizard.

Click on the object and open the application. Examine
the properties, help file, and methods. Presumably
you have the type library loaded: use the object
browser to browse the object. Change the sample data
to your own data, to make it easier to see what you
are doing.

(david)
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response to
share.

Starting with the Chart Wizard, I can't get the Access scatter chart to
place the data points correctly, ie at the intersection of their XY
position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 12 '06 #12

P: n/a
DFS
david epsom dot com dot au wrote:
It's not a bug, it's just you.

Or rather, you and a fairly difficult user interface.
In this case, a basically useless wizard.
I don't think you'll get very far using the wizard.

Click on the object and open the application. Examine
the properties, help file, and methods. Presumably
you have the type library loaded: use the object
browser to browse the object. Change the sample data
to your own data, to make it easier to see what you
are doing.
If you have a screenshot of a successful scatter chart you produced in
Access with your own data, please post a link to it.

I hand coded a form - it looks great, but it took me 6 hours to get it just
so, with the scaling, labels, dealing with outliers, and other options.

Thanks


(david)
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net. ..
>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 12 '06 #13

P: n/a
6 hours? it doesn't get any easier if you use the
graph object.

You have a file called Report3.snp

<http://www.yousendit.com/transfer.php?action=download&ufid=58057EDF27CD8A02 >

(2 KB) from waiting for download.

(david)

"DFS" <nospam@dfs_.comwrote in message
news:f1*******************@bignews6.bellsouth.net. ..
david epsom dot com dot au wrote:
>It's not a bug, it's just you.

Or rather, you and a fairly difficult user interface.

In this case, a basically useless wizard.
>I don't think you'll get very far using the wizard.

Click on the object and open the application. Examine
the properties, help file, and methods. Presumably
you have the type library loaded: use the object
browser to browse the object. Change the sample data
to your own data, to make it easier to see what you
are doing.

If you have a screenshot of a successful scatter chart you produced in
Access with your own data, please post a link to it.

I hand coded a form - it looks great, but it took me 6 hours to get it
just so, with the scaling, labels, dealing with outliers, and other
options.

Thanks


>(david)
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.net ...
>>I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone posts
questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter chart
to place the data points correctly, ie at the intersection of their
XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks


Jul 12 '06 #14

P: n/a
DFS
david epsom dot com dot au wrote:
6 hours? it doesn't get any easier if you use the
graph object.
<http://www.yousendit.com/transfer.php?action=download&ufid=58057EDF27CD8A02 >

No offense, but that's hideous.

My custom chart is beautiful (if I do say so), and is just what the doctor
ordered. Plus, my labels next to the data points show the month, and if you
hover the mouse you see the actual data, not the derived pairs you see in
Excel (like 0.19922, -.12582). And I show the most current data point in
red.



(david)

"DFS" <nospam@dfs_.comwrote in message
news:f1*******************@bignews6.bellsouth.net. ..
>david epsom dot com dot au wrote:
>>It's not a bug, it's just you.

Or rather, you and a fairly difficult user interface.

In this case, a basically useless wizard.
>>I don't think you'll get very far using the wizard.

Click on the object and open the application. Examine
the properties, help file, and methods. Presumably
you have the type library loaded: use the object
browser to browse the object. Change the sample data
to your own data, to make it easier to see what you
are doing.

If you have a screenshot of a successful scatter chart you produced
in Access with your own data, please post a link to it.

I hand coded a form - it looks great, but it took me 6 hours to get
it just so, with the scaling, labels, dealing with outliers, and
other options.

Thanks


>>(david)
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.ne t...
I posted this question yesterday, and nothing but silence.

I looked through cdma in Google, and it seems whenever someone
posts questions about scatter charts, they get ignored.

So, hopefully, this time, someone will have some brilliant response
to share.

Starting with the Chart Wizard, I can't get the Access scatter
chart to place the data points correctly, ie at the intersection
of their XY position. They only plot along the Y axis.

Is this a known bug, or is it something I'm doing?

Thanks

Jul 12 '06 #15

P: n/a
DFS wrote:
Thanks Salad. The problem is, the scatter charts in Excel work fine. I
just can't get them to work in Access.
FWIW, I've a major A97 app that produces charts (but no scatter stuff,
unfortunatley) I've rewritten for A2003. My usual tactic is to record a
macro in Excel and then "translate" the VBA to Access. However, I've
found theis approach much more difficult to do in A2003 and in the end,
for one area, simply had to copy objects and code directly from my A97
app to the A2003 app. I find it very difficult to get things to work
just right in chart automation in A2003, far more finicky than I
remember in A97.

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

P: n/a
No offense, but that's hideous.

I agree. And I'm just guessing! I haven't even /seen/ your
chart, and I still think it's better :~)

I think for the work you put in, you got a better result than
if you had persevered with the chart object.

Simple charts work ok if you put some work into them,
but the chart object is difficult and inflexible.

There are third party chart objects which I assume are better.

I think that a simple pie graph looks good in MS Chart, so the
chart object is good for doing power point style management
reports. The further away you get from that, the less useful
MS Chart is.

(david)

"DFS" <nospam@dfs_.comwrote in message
news:ci*******************@bignews6.bellsouth.net. ..
david epsom dot com dot au wrote:
>6 hours? it doesn't get any easier if you use the
graph object.

><http://www.yousendit.com/transfer.php?action=download&ufid=58057EDF27CD8A02 >


No offense, but that's hideous.

My custom chart is beautiful (if I do say so), and is just what the doctor
ordered. Plus, my labels next to the data points show the month, and if
you hover the mouse you see the actual data, not the derived pairs you see
in Excel (like 0.19922, -.12582). And I show the most current data point
in red.



>(david)

"DFS" <nospam@dfs_.comwrote in message
news:f1*******************@bignews6.bellsouth.net ...
>>david epsom dot com dot au wrote:
It's not a bug, it's just you.

Or rather, you and a fairly difficult user interface.

In this case, a basically useless wizard.

I don't think you'll get very far using the wizard.

Click on the object and open the application. Examine
the properties, help file, and methods. Presumably
you have the type library loaded: use the object
browser to browse the object. Change the sample data
to your own data, to make it easier to see what you
are doing.

If you have a screenshot of a successful scatter chart you produced
in Access with your own data, please post a link to it.

I hand coded a form - it looks great, but it took me 6 hours to get
it just so, with the scaling, labels, dealing with outliers, and
other options.

Thanks



(david)
"DFS" <nospam@dfs_.comwrote in message
news:iw*******************@bignews6.bellsouth.n et...
I posted this question yesterday, and nothing but silence.
>
I looked through cdma in Google, and it seems whenever someone
posts questions about scatter charts, they get ignored.
>
So, hopefully, this time, someone will have some brilliant response
to share.
>
Starting with the Chart Wizard, I can't get the Access scatter
chart to place the data points correctly, ie at the intersection
of their XY position. They only plot along the Y axis.
>
Is this a known bug, or is it something I'm doing?
>
Thanks


Jul 13 '06 #17

P: n/a
DFS
david epsom dot com dot au wrote:

There are third party chart objects which I assume are better.
Yes. Check out these charting tools

http://www.xcelsius.com/Examples/Overview.html

Jul 13 '06 #18

P: n/a
DFS wrote:
david epsom dot com dot au wrote:

There are third party chart objects which I assume are better.

Yes. Check out these charting tools

http://www.xcelsius.com/Examples/Overview.html
Yes, those third-party tools are very lovely. I hope to be able to
create masterpieces like that someday. But guess what? Based on my
reading of the PDF Reference Manual I believe that the PDF graphic
environment has all the tools for me to do everything you see on that
sample page and more eventually. Also, if I need something in a hurry
it's nice to know there's a shortcut :-).

James A. Fortune
CD********@FortuneJames.com

Jul 13 '06 #19

This discussion thread is closed

Replies have been disabled for this discussion.