Editing Source Data in Charts
 

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

Editing Source Data in Charts
 

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/ChartsH...esFormula.html

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


"F. Lawrence Kulchar" wrote in
message ...
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