Source Data / Series

  • Thread starter Thread starter F. Lawrence Kulchar
  • Start date Start date
F

F. Lawrence Kulchar

I have 8 charts in one of my workbooks in one of my files.
Every month, I change the source data (series) to include the most recent
month for all of the series within the chart.

For example, I change: {from} =Sheet1!$V$18:$V$600
{ to } =Sheet1!$V$18:$V$650


Here is the dilemma:

WHEN I AM FINISHED CHANGING ALL THE SERIES IN THE CHART, I PRESS 'OKAY'.

Instead of my cursor remaining where it was before I edited the chart, i.e.
somewhere near the chart, THE CURSOR JUMPS TO THE BEGINNING OF THE WORKBOOK
MAKING IT NECESSARY FOR ME TO SCROLL ALL THE WAY BACK TO WHERE I WAS TO EDIT
THE REMAINING CHARTS!!!!!

Since my workbook is quite large, this becomes an inconvenience.

CAN ANYONE HELP ME AUGMNENT THIS SITUATION??

Thank you.

FLKulchar
 
I don't know about the cursor jumping all about.

You could either create some defined names on the sheet and make dynamic
charts:

http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

which may be a bit of work for existing charts (but you'll only have to do
it once), or you could use this little utility to change all the series
formulas of all the charts in one step:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

In your example, change $600 to $650.

- Jon
 
Back
Top