Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Source Data / Series
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/...umnChart1.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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "F. Lawrence Kulchar" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |