View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default Source Data / Series

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