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