Selecting a point on a chart in Excel 2007 on Windows 7

[Kirill]

Hi,

This may seem like a repost, but I believe that the first post was not
recognized as from MSDN Subscriber. If this message lacks any significant
details, I'll gladly provide them in a reply.

I have a macro that operates on a point, selected on a chart. It works fine
in Excel 2003 on Windows XP, Windows 7, and in Excel 2007 on Windows XP.
However, I can't seem to select a point by clicking on it in Office 2007 on
Windows 7.

Sometimes when I select the chart *some* point gets selected, but I can't
change that selection either by clicking on another point or by using the
keyboard (both ways work fine in Excel 2003).

Is there a way to *reliably* select a point on a chart in Excel 2007?

Thank you!

 

[JLGWhiz]

Can't offer a solution to your selection problem, but about response on this
site, it is not staffed by Microsoft employees. The people who respond to
users on this site are from all over the world and volunteer their time to
assist beginners, developers and others as much as they can in resolving
their individual problems with VBA code or formulas. Some of those who
respond are professionals who have their own companies that deal in products
that use VBA and other programming languages, some are just users who have
developed programming skills sufficiently to assist others and some are
casual observers who happen to open a thread that they believe they know how
to resolve. So if no one responds to your post, it is not because you are
not a MSDN subscriber, it is either because they do not know the answer,
they overlooked the posting or they do not understand the problem
sufficiently to respond to it. Some of us review prior postings to see if
any were missed and might respond to them a day after they are posted, so
posters should note their subject line when posting and use that to find the
posting at a later date.

 

[Ji Zhou]

Hello Kirill,

Our managed newsgroup support team still supports the MSDN Subscribers in
the managed newsgroup. Just recently, the server has some issues that it
cannot pick up the MSDN Subscriber posts. The tool team is now working on
this. I am sorry for the inconveniences taken to you.

Based on my understanding to the post, the issue we concern is not related
to the Excel programming Macro, right? It is that we cannot manually select
a point in an Excel chart. And this issue only happens in your Windows 7 and
Excel 2007.

I created a line type chart in my Excel 2007, Windows 7. And if I click a
point, first all points in that series are selected. If I click that point
again, then only that specified point is selected. So it works for me. Are
you reproducing the issue in only one machine or many test machines?

For it is not related to the Excel programming, I think maybe the Excel
chart newsgroup is more appropriate, but that is not a managed newsgroup,
http://www.microsoft.com/office/com...microsoft.public.excel.charting&lang=en&cr=US

And I would also suggest to
1.Apply all service pack update to the Excel 2007
2.Disable all addins in your Excel 2007 to make sure this issue is not
caused by an addin




Best regards,
Ji Zhou
Microsoft Online Community Support

 

[Jon Peltier]

Kirill -

Excel charting through 2003 was pretty reliable and the related
interfaces were effective. Excel 2007 changed all that, unfortunately
not for the better.

I've experienced this problem when the chart had a lot of points close
together. It's like the points have a larger envelope than just the
visible marker, and one point's envelope may obscure the next point.

I don't know how to avoid this problem.

- Jon

 

[Kirill]

Dear Ji Zhou,

Ji Zhou wrote...

Our managed newsgroup support team still supports the MSDN Subscribers in
the managed newsgroup. Just recently, the server has some issues that it
cannot pick up the MSDN Subscriber posts. The tool team is now working on
this.

This is really "good news, bad news" situation. I hope issues will be fixed
soon, because I really like the Managed Newsgroups! Side note: if we can
have a "test group" just to verify that aliases work, it would be absolutely
awesome!

Based on my understanding to the post, the issue we concern is not related
to the Excel programming Macro, right?

Technically, you're right. But as a macro developer I was concerned that my
macro does not work as expected.

It is that we cannot manually select a point in an Excel chart.
And this issue only happens in your Windows 7 and Excel 2007. ....
Are you reproducing the issue in only one machine or many test machines?

On multiple machines, however Excel 2007 and Windows 7 are required.

For it is not related to the Excel programming, I think maybe the Excel
chart newsgroup is more appropriate...
http://www.microsoft.com/office/com...microsoft.public.excel.charting&lang=en&cr=US

And I would also suggest to
1.Apply all service pack update to the Excel 2007
2.Disable all addins in your Excel 2007 to make sure this issue is not
caused by an addin

Thank you for these three suggestions too!

 

[Kirill]

Dear Jon,

Jon Peltier wrote

Excel charting through 2003 was pretty reliable and the related interfaces
were effective. Excel 2007 changed all that, unfortunately not for the
better.

In oppose to Ji Zhou's response, this is real bad news

I've experienced this problem when the chart had a lot of points close
together. It's like the points have a larger envelope than just the
visible marker, and one point's envelope may obscure the next point.

I thought about it and tested the theory, but even very distant points could
not be selected *reliably*. I still need to follow up on Ji Zhou's
suggestion:

Ji Zhou> And if I click a point, first all points in that series
Ji Zhou> are selected. If I click that point
Ji Zhou> again, then only that specified point is selected.

Thanks for your input!

 

[Jon Peltier]

I thought about it and tested the theory, but even very distant

points could not be selected *reliably*.

If you miss the point and the click is registered on the connecting
line, it might be treated as a click on the other point.

I still need to follow up on Ji Zhou's suggestion:

Ji Zhou> And if I click a point, first all points in that series
Ji Zhou> are selected. If I click that point
Ji Zhou> again, then only that specified point is selected.

A mouse over event doesn't need this two click process, it should simply
respond to the point under the cursor. This is problematic in 2007.

- Jon

 

[Jon Peltier]

As I replied in the programming group:

Excel charting through 2003 was pretty reliable and the related
interfaces were effective. Excel 2007 changed all that, unfortunately
not for the better.

I've experienced this problem when the chart had a lot of points close
together. It's like the points have a larger envelope than just the
visible marker, and one point's envelope may obscure the next point.

I don't know how to avoid this problem.

- Jon