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  

Scrollbar on Chart Jumps to Left when Chart is Clicked



 
 
Thread Tools Display Modes
  #1  
Old April 29th, 2005, 03:22 PM
Bob
external usenet poster
 
Posts: n/a
Default Scrollbar on Chart Jumps to Left when Chart is Clicked

I fiddled around with 'offset' and a scrollbar, and now I can change the
range of my chart just by clicking on the scrollbar. However, there is a
problem with placement.

If I click on the chart, and move the scrollbar to where I want it, when I
click *OFF* the chart, the scroll bar moves about double the distance from
top left that it was when the chart was clicked. It's like the scrollbar
thinks I'm doubling the size of the chart when I click off the chart. If
I position the scrollbar past halfway from top left, when I click off the
chart the scrollbar totally disappears.

Or, to put it another way, WHEREVER the scroll bar is on the chart (while
I'm editing my data in other cells) if I click on the chart, the scrollbar
jumps towards the top left (about half the distance).

I'm thinking this has something to do with the fact that when I pasted the
scroll bar on the chart it first appeared at the top left.

Any ideas?

thanks
john
  #2  
Old April 29th, 2005, 03:38 PM
Bob
external usenet poster
 
Posts: n/a
Default


Just on a whim I went into chart properties and changed it from
"move and size with cells" to
"move but don't size with cells",
and back.

This fixed it. Why?... I don't know.

  #3  
Old April 29th, 2005, 03:46 PM
Bob
external usenet poster
 
Posts: n/a
Default

Another observation for the vast NG archive:

I increased the zoom. The chart got bigger. I clicked on the chart and
the scrollbar jumped to the left. But now, if I click off and on the
chart, the scrollbar stays were it was. I think it's safe to assume this
was all just another little bug in Excel.
  #4  
Old April 29th, 2005, 05:46 PM
Bob
external usenet poster
 
Posts: n/a
Default

After fiddling around with it some more I see it's a zoom problem. In
order to change the zoom I have to be 'off' the chart. When I change it,
the chart grows or shrinks, and the scrollbar seems to stay over the same
ROW as it should, but the horizontal placement stays the same relative to
the screen, NOT THE COLUMN. Whatever I change the zoom to, the scroll bar
stays (horizontally) pretty much in the same place (about the middle of
the screen).

If I click on the chart in any of these zoom settings, the scrollbar jumps
to where it should be on the re-sized chart if everything were shrinking
and growing to scale like it should when zoom is changed.

In other words, the horizontal placement of the scrollbar on the chart,
when the chart is not clicked, is always (roughly) like the zoom is 100
percent. When the chart *IS clicked* horizontal placement works with Zoom
as it should.

The bottom line is: if you don't want the scrollbar jumping around when
you click on and off the chart, you have to leave the zoom at 100, or take
the scrollbar off the chart.

....... unless someone else has some other ideas......?
  #5  
Old April 30th, 2005, 11:30 AM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default

Thanks for sharing your experiences. One thing that stands out is the
zoom setting. I have learnt over the years that XL is best served at
100% zoom. While on occassion I do use it at other settings it is only
for brief durations and I tend to return to 100% as soon as possible.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article opspz8y7jqcpyzb7@win2kvm3test,
says...
After fiddling around with it some more I see it's a zoom problem. In
order to change the zoom I have to be 'off' the chart. When I change it,
the chart grows or shrinks, and the scrollbar seems to stay over the same
ROW as it should, but the horizontal placement stays the same relative to
the screen, NOT THE COLUMN. Whatever I change the zoom to, the scroll bar
stays (horizontally) pretty much in the same place (about the middle of
the screen).

If I click on the chart in any of these zoom settings, the scrollbar jumps
to where it should be on the re-sized chart if everything were shrinking
and growing to scale like it should when zoom is changed.

In other words, the horizontal placement of the scrollbar on the chart,
when the chart is not clicked, is always (roughly) like the zoom is 100
percent. When the chart *IS clicked* horizontal placement works with Zoom
as it should.

The bottom line is: if you don't want the scrollbar jumping around when
you click on and off the chart, you have to leave the zoom at 100, or take
the scrollbar off the chart.

...... unless someone else has some other ideas......?

  #6  
Old May 1st, 2005, 02:06 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

Here's a fun zoom trick. Make an embedded chart. Put the zoom at 100%, copy the
chart and paste it. Same size (well, not exactly; it seems to have gained a pixel in
height and width).

Change the zoom to 75%, copy the original chart, and paste it. The new chart is 75%
the size of the original (again, not exactly, it's 75.15% in width and 76.84% in
height).

Change the zoom to 50%, copy the original chart, and paste it. Whoa, the new chart
is now half the size of the original (50.31% in width, 53.33% in height).

This behavior occurs when you select a chart normally. If you hold down shift or
control while selecting the chart, then copy and paste, the pasted chart is exactly
the same size as the copied chart.

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

Tushar Mehta wrote:

Thanks for sharing your experiences. One thing that stands out is the
zoom setting. I have learnt over the years that XL is best served at
100% zoom. While on occassion I do use it at other settings it is only
for brief durations and I tend to return to 100% as soon as possible.


 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get my y axis on the left hand side of my chart? Aneleh Charts and Charting 3 February 8th, 2005 05:17 PM
Selecting Charts in a Macro Herman Merman Charts and Charting 1 August 18th, 2004 12:25 AM
Chart menu visible property Sandy V Charts and Charting 8 May 17th, 2004 01:39 PM
Styles for chart Debra Dalgleish Charts and Charting 1 October 3rd, 2003 12:27 PM
Chart Object Name LB Charts and Charting 4 September 26th, 2003 11:27 PM


All times are GMT +1. The time now is 11:00 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.