Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a point on a chart in Excel 2007 on Windows 7
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/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 Best regards, Ji Zhou Microsoft Online Community Support "Kirill" wrote in message ... 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! -- Kirill. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a point on a chart in Excel 2007 on Windows 7 | Charts and Charting in Excel | |||
Selecting a point on a chart in Excel 2007 on Windows 7 | Excel Programming | |||
MS Excel/Power Point 2007 using OCX - Windows 7 (32-64 bit) ? | Excel Programming | |||
Excel 2007 Chart Doesn't Allow an XY Point to be Dragged | Charts and Charting in Excel | |||
Selecting point from chart while executing macro- is it posible? | Excel Programming |