Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2006

Tip: Looking for answers? Try searching our database.

Editing Source Data in Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
F. Lawrence Kulchar - 05 Nov 2006 12:36 GMT
This is a simple question:

When I change my series data, e.g. by doing the foillowing:

  right click and highlight       Source Data
  go to                                 Series

   change the data from        A6:A26
                           to
                                          A1:A26

   then click                               OK

Why does my cursor then go to my spreadsheet (usually near the beginning)
instead of staying within the chart...

In other words, I must navigate back to my charts after I change one of them.

Is this unavoidable??

Thanks...

FLKulchar
Jon Peltier - 05 Nov 2006 15:18 GMT
When you click in the box containing the range address, Excel highlights the
range, scrolling the window if necessary. It does not scroll back.

An alternative approach which does not scroll the window is to select the
series, and edit the addresses in the SERIES formula displayed in the
formula bar. See this article for more information:

   http://peltiertech.com/Excel/ChartsHowTo/ChartSeriesFormula.html

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

> This is a simple question:
>
[quoted text clipped - 20 lines]
>
> FLKulchar
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.