Axis not highlighting when viewing selections

  • Thread starter Thread starter S&K
  • Start date Start date
S

S&K

Hello!

When using Office 2003, we are experiencing a problem
with excel graphs. When viewing the source data, I
select a series. Then choose the X Values, it WILL show
the selected values. I then close out of that which
takes me back to the Source data, I then choose the Y
Values. This does NOT show the selected values. I tried
going directly to the Y Values first on another series,
and it appears that whichever axis is selected first will
show, the second will not. This is a major hassle when
you are dealing with complicated graphs that contain many
many rows and several different series.

Feedback is appreciated!

Thanks,

Brad
 
Brad -

That's a pain in the neck. I just noticed the same (mis)behavior in
Excel XP, and in 2000. So you're not crazy.

I did notice that changing the series reset this problem, so the first
thing you select after switching (not the first thing before switching)
is highlighted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon,
Thanks for the input! Do you think MS will come out with
a patch for this, or are they even aware of such an
issue? So you suggest switching series constantly so you
are always looking at the first selected axis?
Thanks,
Brad
 
Brad -

It's easier than always switching series. I played around after writing
back, and learned a bit about its behavior. It seems that if one RefEdit
has focus, clicking in another does not activate the marching ants
marquee. But you can tab between the boxes, and that seems to transfer
focus in such a way that the next range is highlighted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon,
This was most helpful, thanks!
-----Original Message-----
Brad -

It's easier than always switching series. I played around after writing
back, and learned a bit about its behavior. It seems that if one RefEdit
has focus, clicking in another does not activate the marching ants
marquee. But you can tab between the boxes, and that seems to transfer
focus in such a way that the next range is highlighted.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______




.
Click to expand...
 
Back
Top