Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Range - Change workbook
Hi there,
I have searched through this forum cannot find a solution to what I need so here goes (or perhaps I have missed it). I have a workbook containing 11 worksheets - one for each country with the first worksheet containing a set of standard charts which are reused for each country. I am currently manually amending the data range and selecting the worksheet and highlighting the data for each country (so have to do this 10 times). The data is in the same location on each country worksheet so really the only amendment is the worksheet name. How do you recommend that I speed up this process. I use a pivot chart for another report and find brill for this type of thing as I just click the country from the drop down box) and wonder if I could set up this type of principal for my workbook. Hope all this makes sense. Rgds, Teddy |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Range - Change workbook
In addition to below, I read about the chart formula on
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html and when I tried manually editing the chart formula it is very tricky and accidentally changes the range rather than the worksheet name only. Also tried edit/replace which does not work. Thanks again. Teddy. "Teddy" wrote: Hi there, I have searched through this forum cannot find a solution to what I need so here goes (or perhaps I have missed it). I have a workbook containing 11 worksheets - one for each country with the first worksheet containing a set of standard charts which are reused for each country. I am currently manually amending the data range and selecting the worksheet and highlighting the data for each country (so have to do this 10 times). The data is in the same location on each country worksheet so really the only amendment is the worksheet name. How do you recommend that I speed up this process. I use a pivot chart for another report and find brill for this type of thing as I just click the country from the drop down box) and wonder if I could set up this type of principal for my workbook. Hope all this makes sense. Rgds, Teddy |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Range - Change workbook
I had another look at Mr Peltier's website and found my solution. If you
read this I want to say thank you so much for your brilliant solutions. You have made my life so much easier. Rgds, Ted "Teddy" wrote: Hi there, I have searched through this forum cannot find a solution to what I need so here goes (or perhaps I have missed it). I have a workbook containing 11 worksheets - one for each country with the first worksheet containing a set of standard charts which are reused for each country. I am currently manually amending the data range and selecting the worksheet and highlighting the data for each country (so have to do this 10 times). The data is in the same location on each country worksheet so really the only amendment is the worksheet name. How do you recommend that I speed up this process. I use a pivot chart for another report and find brill for this type of thing as I just click the country from the drop down box) and wonder if I could set up this type of principal for my workbook. Hope all this makes sense. Rgds, Teddy |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Range - Change workbook
Hi, took another look as Mr Peltier's blog and found my solution! Thank you
so much Mr Peltier for your wonderful solutions. Rgds, Ted. "Teddy" wrote: Hi there, I have searched through this forum cannot find a solution to what I need so here goes (or perhaps I have missed it). I have a workbook containing 11 worksheets - one for each country with the first worksheet containing a set of standard charts which are reused for each country. I am currently manually amending the data range and selecting the worksheet and highlighting the data for each country (so have to do this 10 times). The data is in the same location on each country worksheet so really the only amendment is the worksheet name. How do you recommend that I speed up this process. I use a pivot chart for another report and find brill for this type of thing as I just click the country from the drop down box) and wonder if I could set up this type of principal for my workbook. Hope all this makes sense. Rgds, Teddy |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Range - Change workbook
You're welcome.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Teddy" wrote in message ... I had another look at Mr Peltier's website and found my solution. If you read this I want to say thank you so much for your brilliant solutions. You have made my life so much easier. Rgds, Ted "Teddy" wrote: Hi there, I have searched through this forum cannot find a solution to what I need so here goes (or perhaps I have missed it). I have a workbook containing 11 worksheets - one for each country with the first worksheet containing a set of standard charts which are reused for each country. I am currently manually amending the data range and selecting the worksheet and highlighting the data for each country (so have to do this 10 times). The data is in the same location on each country worksheet so really the only amendment is the worksheet name. How do you recommend that I speed up this process. I use a pivot chart for another report and find brill for this type of thing as I just click the country from the drop down box) and wonder if I could set up this type of principal for my workbook. Hope all this makes sense. Rgds, Teddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change data range graph from 0-60 to 40-60 | Charts and Charting in Excel | |||
How do I subtotal a range of data and export to a new workbook? | Excel Discussion (Misc queries) | |||
Excel use another Workbook for data validation range. | Excel Discussion (Misc queries) | |||
?-Change data series range as data is entered? | Charts and Charting in Excel | |||
How do I change a range name back to the underlying data range? | Excel Worksheet Functions |