Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Named-range source-data for pie charts on copied worksheets
I have to finally concede that I'm stuck and have to ask for advice. I
am using Excel 2000 and have been able to use Andy Pope's help on "Automatic removal of zero values in pie chart". That works fine. But if I copy the worksheet, the pie chart on the copied (new) worksheet references the named range as defined on the original worksheet. My named ranges, which the pie chart references, a PieLabels=OFFSET(blank!$O$26,0,0,COUNT(blank!$N$26 :$N$34),1) PieValues=OFFSET(blank!$N$26,0,0,COUNT(blank!$N$26 :$N$34),1) So, one solution might be to define the same named range on different worksheets and prefix the Range Name by the worksheet name. One problem with this though is that it appears to only work for existing worksheets, I need something that will work for new (copied) worksheets. Reason being is that the first worksheet will be blank, and I wish to make a copy of this each time I have a new set of data. But when I do this, the source data for the pie chart on the new worksheet is derived from the named range as defined on the worksheet which was copied. So I have figured out that a cell formula for the current worksheet is: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99) But I don't know how that helps or what I can do with that formula in relation to named ranges and the source data for my pie chart. So, what am I missing? How can I make my named ranges and pie charts that little bit more flexible and dynamic? Note that I do not wish to use a macro or VBA programming to achieve this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - 2 Worksheets one Named Range | Excel Worksheet Functions | |||
same named range on multiple worksheets? | Excel Discussion (Misc queries) | |||
Setting source data range with Charts | Charts and Charting in Excel | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |