A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2010, 07:13 PM posted to microsoft.public.excel.programming,microsoft.public.excel.charting
Kirill
external usenet poster
 
Posts: 1
Default Selecting a point on a chart in Excel 2007 on Windows 7

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/comm...a ng=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.

Kirill wrote
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?



  #2  
Old April 17th, 2010, 07:22 PM posted to microsoft.public.excel.programming,microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Selecting a point on a chart in Excel 2007 on Windows 7

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/16/2010 2:13 PM, Kirill wrote:
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/comm...a ng=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.

Kirill wrote
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.