Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Any Graph/Chart Object Programmer Out There

0 views
Skip to first unread message

Chase Saunders

unread,
May 15, 2002, 1:08:21 PM5/15/02
to
Hi - I am trying to program the ActiveX component for MS Graph in Visual
Basic. So far, I think the documentation sucks.

If you have done this or know of any groups/online resources I would greatly
appreciate an email (I will not be monitoring this newsgroup) - just remove
the "spamfree." in smapfree...@burgessinc.com
----------------------------------------

[ In particular, I am trying to set a property to assign series to the
correct y-axis, as there are two of them in my graph. I found the property
and can even read it's value. The help says the property is not read-only,
but if I try to set it programmaticalyl I get an error saying it is! Do I
need to set all this before the graph is "run" somehow?? ]

Thanks

Chase


Tushar Mehta

unread,
May 15, 2002, 6:02:43 PM5/15/02
to
Let me see if I can rewrite this.

"Point me to some free groups/online resources. Of course, I can't be
bothered to check this NG. At the same time, I must protect myself
against spam. So, you do all the work and create a correct email
address.

"Oh, and I'm too busy to waste any time checking for spelling errors.
So, find and fix the typos before you remove "spamfree." in
smapfree...@burgessinc.com"

OK, any takers?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Microsoft MVP -- Excel

In article <9CwE8.26783$fU2.2...@bin8.nnrp.aus1.giganews.com>,
nospam....@burgessinc.com says...

Gord Dibben

unread,
May 15, 2002, 6:44:07 PM5/15/02
to
Tushar

You get the "blue pencil award" for most original editing.

Right on the mark(or is that mrak?)

Gord Dibben Excel MVP - XL97 SR2

On Wed, 15 May 2002 18:02:43 -0400, Tushar Mehta <ng_p...@bigfoot.com>
wrote:

Chase Saunders

unread,
May 16, 2002, 1:19:07 PM5/16/02
to
As someone who has spent hundreds, if not thousands of hours helping out
other programmers on newsgroups, I am disgusted by your reply. Perhaps you
are new to newsgroups and news ettiquite... Even the most prolific newgroup
participants have time to participate regularly in a finite number of
newsgroups. It is standard ettiqute to ask for an email reply if, on
occasion, a person posts to a newsgroup in which he or she does not normally
participate. Rather than being a discourtesy to the regular posters, it is
the exact opposite; by asking for an email reply I was being honest about
the fact that I am not a regular contributor, about the fact that if you do
not have time to send a simple email then you may want to skip the whole
message.

Let me see if I can rephrase YOUR message FOR YOU -
===============================================================
My name is Tushar Mehta. Instead of spending my time helping a person who
has been up front about the fact that this is the only post he will ever
make to this newsgroup, I prefer to spend it writing hostile emails and
demonstrating my superiority complex and lack of nettiquite.

Even though a quick search of newsgroups reveals that I regularly copy the
poster's email and remove anti-spam wording without even being asked, I'll
be very offended if you do ask me to do this.

Even though a quick search of newsgroups reveals that "I rarely, if ever,
use MS Graph."
(http://groups.google.com/groups?hl=en&lr=&frame=right&th=f81ee126e9c3886c&s
eekm=MPG.174b8e713c78f68198a615%40msnews.microsoft.com#s)
I choose to spend my time attempting to denigrate and shame those who do.

I never post an question, but I spend a vast amount of time answering other
people's questions. This makes me feel like a big shot (oh yeah, it's also
how I pick up clients.) That's why I don't like people who use anti-spam
techniques... the purpose of my whole presence is newsgroups is to generate
a weak form of spam that will get people onto my website.

It looks like the only ettiquite rule I can follow is not cross-posting...
but maybe that is becuase I only work on excel and charting.
===============================================================

Tushar: Why don't you get outside a little more often, or spend your time
on the newgroups doing something constructive, rathern than demonstrating
your own pettiness.

P.S. In case you hadn't noticed, I came back to check for messages. Thanks
for wasting my time.


S...@internet.org

unread,
May 16, 2002, 2:40:55 PM5/16/02
to
You post here, you get your answers here.

People have different reasons for occasionally mailing an
OP directly with a carbon to the NG. Your message
clearly did not meet Tushar Mehta's necessary conditions
to merit a direct reply - though these criteria may be
unpublished. Of course, if I was really bothered a Google
search may reveal any such guidelines, but I am happy
enough to check back in an NG when I am the OP
regardless of my status as a regular monitor of that NG.

Anyway, a quick Google search using"ms graph visual basic"
reveals a host of articles including an example from
Microsoft itself. A sufficiently determined and self-reliant
programmer would at least have progressed beyond just
asking for pointers without documenting what preliminary
research s/he had performed.

-- Sam


"Chase Saunders" <nospam....@burgessinc.com> wrote in message news:fSRE8.12972$e66.1...@bin6.nnrp.aus1.giganews.com...

Brian Reilly, MS MVP

unread,
May 16, 2002, 3:59:27 PM5/16/02
to
Chase,

>that if you do
>not have time to send a simple email then you may want to skip the whole
>message.
If you don't have the time to come back and check the NG for your
answer where others might also learn from your question and our
responses, we will do exactly as you request - skip the whole message.


Which is what I will do.

Brian Reilly, MS MVP

Harald Staff

unread,
May 16, 2002, 4:26:45 PM5/16/02
to
Yeah sure. An author search at http://groups.google.com/ reveals like three
postings per month, total 519 postings (including this windful thread). So
you are either very very old or extremely slow. Or maybe there's a third
option.

Best wishes Harald

"Chase Saunders" <nospam....@burgessinc.com> wrote in message
news:fSRE8.12972$e66.1...@bin6.nnrp.aus1.giganews.com...

John Walkenbach

unread,
May 16, 2002, 6:31:35 PM5/16/02
to
When I read your original message, my reaction was very similar to Tushar's.
But I chose to simply ignore the message.

There is nothing wrong with requesting an email reply to a newgroup
question. But I find a lot wrong with asking respondents to edit your email
address in order to do so. The implication is that your time is more
valuable than the person who replies.

BTW, a search at google reveals that you've used your *real* email address
in at least 300 archived posts. The email-harvesting robots already have
your address, so what's the point of trying to obscure it now? We all get
spam, Chase, so live with it. I doubt that adding a few bogus characters
in front of your email address is going to have any impact, aside from
pissing off people who take the time to help out in the NGs.

Are you really so busy that you can't spare 30 seconds to check a newsgroup
for a reply?

Getting back to your original question... It would help if you posted the
code that's causing the problem for you. You mentioned that you identified a
property, but you don't say what it is. Was it AxisGroup?

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

Chase Saunders

unread,
May 17, 2002, 10:21:39 AM5/17/02
to
Yes, you are right and wrong. I was an active poster for about 6-9 months
only on usenet. However, I have been a volunteer for several years tutoring
high school and college computer science students. I have also participated
in user groups. Now that I look at my statement I should have been more
clear.... the point is that the attitude here should be to help each
other... all I was doing was asking for help, and in fact I was really
looking for somebody I could PAY for help although my original message did
not state that. There is no reason to flame me for doing so.

Chase

"Harald Staff" <harald...@eunet.no> wrote in message
news:eowRPeR$BHA.1680@tkmsftngp04...

Chase Saunders

unread,
May 17, 2002, 10:25:15 AM5/17/02
to
Your point regarding spam is good... there is no point to trying to hide my
address anymore. As you noticed, I have been trying to use an alias so I
can kill my original address which gets spammed several hundred times per
day.

As others have pointed out, nobody was under any obligation to respond to my
post. Now that I realize how people feel about the anti-spam thing, I will
probably avoid it in the future. However, this is still no reason so flame
me. As you pointed out, all you had to do was skip my post. It wasn't long
or anything.

Also, I just want to point out that I DID come back to check for messages.
The reward for emailing me may well have been a contract to solve my
problem, but obviously I have no way to substantiate that statement at this
time. Again, I was just trying to be honest about the fact I'm not a
regular participant.

Chase

"John Walkenbach" <jo...@j-walk.com> wrote in message
news:ekSVGlS$BHA.1356@tkmsftngp05...

Chase Saunders

unread,
May 17, 2002, 10:32:27 AM5/17/02
to
1) What makes you think I didn't exhaust my own resources before asking for
help. Fact is, I have read all the Microsoft help on the subject and the
help file totally sucks. Most of the other web resources I found in a few
hours of searching basically either (a)point out how bad the docs suck,
(b)show dumbed-down examples like how to change the chart title with code,
(c)refer to the Chart OLE object rather than the ms graph chart object, or
(d)do not really address programming. If you do that google search and
check out a few sites, you will see what I mean.

2) A legitimate use of newsgroups is to post questions with the intentions
of finding professional programmers to hire. Although I did not mention it
and there is no way I can prove it to you, that was in my mind when I
posted. In this case, I don't see why I have an ethical obligation to check
the literature as I have done; there are lots of people out there who get
work from newsgroups, like Tusthar. (However, I realize that the reverse
process, soliciting business, is discouraged unless done tastefully.
Tusthar seems to have done so in a tasteful manner.)

Regarding the ettiquite of asking for email posts, please see my separate
post addressing all members of this thread.

Chase


Chase Saunders

unread,
May 17, 2002, 10:41:44 AM5/17/02
to
This is from an article on netiquette. If you want to check the "official"
FAQ in either specific newgroups or for example, the netiquette group, you
will find very similar material. I would post those links but am running
out of time to follow up on this thread:

============================================================
From http://www.newsreaders.com/~link/nwman/Usenet.html

* When asking a question, consider offering to gather replies via email and
post a summary.

* When answering a question, consider a direct email reply in addition to or
instead of a followup posting.

* If you must cross-post, consider using the Followup-To header line to
limit followup postings to a single group. Also consider using a
"Followup-To: poster" header line to request that replies be sent to you via
email rather than being posted. If you use a Followup-To header, mention it
in the body of your posting so that people know what you are doing.

============================================================

As you can see, it is not just my opinion that requesting an email is polite
but it is a long-established convention. My apologies if this group has a
different convention; if I had planned on becoming a regular poster I would
have read your FAQ. The reasons I requested an email reply is that

- This group isn't really about programming, so I did not think the
topic would interest others (perhaps I was wrong, but that's honestly what
was going through my mind.)
- This WAS going to be the only post I made to this group, and I have
answered and asked for email replies in similar situations before without
getting any complaints. I did not think this would have an impact on my
chance of getting a request back - turns out I was wrong, I guess.
- I was really more interested in a personal relationship, as I have
mentioned before, with a view to hire a knowledgable person in this area.

So there you have it. One final point I would like to make is that Tusthar
spent far more time flaming me than tha additional .5 seconds it would have
taken to reply by email. Clearly, he did not want me to see his flame since
he believed I would not be coming back to check for replies. So what was
his motiviation for that post? I think it is fairly obvious, but this is a
matter of opinion.

Chase


Chase Saunders

unread,
May 17, 2002, 10:44:46 AM5/17/02
to
Brian,

That is your right and I don't blame you... after all, I asked for help
while stating my intention not to reciprocate. What bugs me is getting
flamed for doing something that I was perfectly within my rights to do.

That being said, this thread has caused me to do some thinking about how to
post messages that are more likely to get repllies.

Chase


Chase Saunders

unread,
May 17, 2002, 11:38:50 AM5/17/02
to
Also note that you can find at least as many of my posts on the msdn groups,
which were not included in the search you did.


Brian Reilly, MS MVP

unread,
May 18, 2002, 7:35:39 AM5/18/02
to
Chase,
You might try looking at fellow MVP Shyam Pillai's example of
manipulating an ActiveX textbox on a PowerPoint slide. I should think
it might help you get started working the the ActiveX shape in Graph
as well.

http://www.mvps.org/skp/ppt00042.htm

Brian Reilly, PowerPoint MVP

Tushar Mehta

unread,
May 19, 2002, 4:31:24 PM5/19/02
to
Was I rude? Possibly. But then, IMO, it was a 'proportional
response,' to borrow a term from politics.

Did I -- do I -- have anything against you? No, I don't know you. It
was aimed more at all those who post similar missives with the
*implicit* "my time is more valuable than yours" attitude.

You made a series of personal allegations about me. That's your call.
Those who know me in the XL (and other) communities can reach their own
conclusions. I have no intention of getting into a 'pissing contest'
with you or anyone else. That is a decision I've lived by since the mid
'80s when I first discovered electronic communities.

I will comment on your claim that asking for email responses is part of
netiquette. The first instance you quoted about posting a summary of
email responses is targeted at very specific discussions. It would
apply to an instance where one is trying to build a group consensus or
some other collective list (examples being "What would you like to see
in the next version of XL? How would you like to see PTs improved?").
However, even here, the norm has become (at least in the NGs I hang out
in) to 'post and mail.'

Some may consider the second instance you cited as reasonable but *not*
when the cost is borne by the responder. I email my response if two
conditions are met: (a) the address is legit, and (b) I want to add to a
discussion that looks 'closed' or I'm responding to a post that is more
than a day old.

As far as anti-spam mechanisms go, that, IMO, is a decision that I do
*not* have to honor. Check the top 10 (or 20 or 30) posters in the XL
NGs. I don't believe any one of us uses a fake address. We may -- I do
-- use a 'throw away' address. However, inspite of thousands of
messages posted in the past 3+ years, the spam directed to the ng_poster
account is minimal. So low, in fact, that I have not thrown it away!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Microsoft MVP -- Excel

--

In <IE8F8.7007$yl.10...@bin3.nnrp.aus1.giganews.com>, Chase Saunders
<nospam....@burgessinc.com> wrote

Chase Saunders

unread,
May 20, 2002, 7:59:31 AM5/20/02
to
Tushar,

Well I admit my response was reactionary... you're probably a swell guy, I
was mostly trying to satirize your post.

My point in mentioning the email rules was not legalism, but just to show
that it is an accepted convetion of asking for reply by email, for a variety
of reasons (my main one was that this seems to be a non-programming group
and I did not think anybody cared). I spent about 30 seconds searching
google groups for phrases like "please reply by email" and a few others -
there were hundreds of thousands of matches, and I did use quotes in my
search terms to find exact phrases.

These people may be less likely to get responses, but they do not deserve to
be flamed. I still think my post was within the boundaries of politeness,
with one exception:

I do understand why the "nospam" think could tick people off, and I am
convinced by the above argument that it is fairly useless anyway. A
"throwaway address" is much better. However, while this may limit the
number of responses was there really any harm in asking? The way I was
jumped on by you and some others makes me wonder how a newbie could ever
feel comfortable. Most of my experiences with newsgroups have no been like
this at all; people are mainly supportive. In my opinion, there are only a
few things that people should get indignant about on newsgroups, and they
are (a)RTFM and (b)cross-posting to lots of similar groups. But that's just
my opinion.

Later days,

Chase


Frank Isaacs

unread,
May 20, 2002, 4:13:51 PM5/20/02
to
"Chase Saunders" <nospam....@burgessinc.com> wrote in message
news:Dy5G8.85782$fU2.8...@bin8.nnrp.aus1.giganews.com...

> Tushar,
>
> Well I admit my response was reactionary... you're probably a swell guy, I

I've spent some time with Tushar, and I'll have to second the observation
about him being a swell guy. Most especially swell about him - at the risk
of starting a totally different flame war - is that he has never watched a
single episode of The Simpsons, which I have also managed to avoid...And, at
the risk of belaboring the issue about your response being reactionary, I
agree. But, then, I know Tushar...and I can picture the impish grin on his
face as he wrote that satirical reply...


But back on track:

When I go to a ng that I don't normally frequent, asking for help, I do ask
for an email reply. But I think this is a reasonable method:

"PS: email cc: appreciated"

And I never munge my address. I will go back and check - after all, I asked
the question - but email will of course alert me faster. I've never had any
complaints with this method, and I've found the majority of folks will honor
the (in my opinion, tasteful) request. Rarely, folks say "no way" but still
answer in the NG. I appreciate it just as much (as long as the answer is
correct).
--

HTH -

-Frank Isaacs
Microsoft Excel MVP
http://vbapro.com

John Walkenbach

unread,
May 20, 2002, 4:40:07 PM5/20/02
to
"Frank Isaacs" <fr...@dolphintechnology.com> wrote

> about him being a swell guy. Most especially swell about him - at the risk
> of starting a totally different flame war - is that he has never watched a
> single episode of The Simpsons, which I have also managed to avoid...

Yeah, and I don't hold that particular character flaw against EITHER of you.
Some people just can't appreciate the best show on TV.

BTW, my daughter forced me to watch an episode of Star Trek a few months
ago. B-O-R-I-N-G.

-John


Chase Saunders

unread,
May 24, 2002, 3:57:16 PM5/24/02
to
I'm not really a star trek fan either, but I thought we were trying to AVOID
another flame war!!!

Chase


Frank Isaacs

unread,
May 28, 2002, 12:58:32 PM5/28/02
to
"John Walkenbach" <jo...@j-walk.com> wrote in message
news:OtNbN5DACHA.1864@tkmsftngp04...
All I can say is, you have way too much time on your hands :-)

-Frank

PS: It isn't quite that I can't appreciate it...I just have never given
myself the *opportunity* to.

PPS: How about Star Wars? Just saw Episode II yesterday, and despite all the
negative publicity, I loved it!

0 new messages