Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default How to move location of chart within a worksheet?

When I create a chart, its initial location on a
worksheet seems to be determined with where the
"cursor" (selected cell?) is at them time.

With nearly 10900 rows, sometimes this leaves the
chart near row 10900.

What is the fastest way to move the chart near
col X row 1 after the fact?

(Hindsight is 20-20.)

The only way I now is to drag it up. But that
can take a lot of time as Excel scolls the rows
down to show movement.

If there is option to disable display updates
during such drag operations, where is it?

(But if I disable display updates, how do I see
where I am while I am dragging?)

Of course, I would prefer to learn that there
is a "location" option that allows me to control
the col/row position of the chart.

(None that I see with the real "location" option
-- unless there is some syntax I am not aware of.)

Finally, if I must drag, are there tricks to use
that would speed things up.

For example, I set the view to 25%. That helps.

  #2   Report Post  
 
Posts: n/a
Default

I wrote:
What is the fastest way to move the chart near
col X row 1 after the fact?


Cut-and-paste. Klunk!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Cursor wil not move left in worksheet Gwen Excel Worksheet Functions 3 March 29th 05 07:05 PM
Change position of move or copy worksheet option in Excel JesseAviles Excel Discussion (Misc queries) 1 February 22nd 05 10:25 PM
How do I remove empty chart plots from linked worksheet charts Lee IT Charts and Charting in Excel 3 January 31st 05 04:31 PM
How To Refresh Chart Data Without Calculating The Worksheet Carl Bowman Charts and Charting in Excel 5 January 19th 05 09:28 PM


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

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

About Us

"It's about Microsoft Excel"