Editing Source Data in Charts

  • Thread starter F. Lawrence Kulchar
  • Start date
F

F. Lawrence Kulchar

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Source Data / Series 1
Not plot a data series in a chart but still display in data table 1
editing chart series data w/ "keyboard only" (2007) 2
chart legend changing when I use Select data 1
Data disappears when I edit the chart. 1
Variable series multi line chart? 1
Charts dont refresh to show changes to data sheet 0
User Selectable Series and Number of Series for Line Chart 2

Top