Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Source Data - Series Tab | Charts and Charting in Excel | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) | |||
How do I change the order of the series in the Source Data? | Charts and Charting in Excel |