Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to ask a chart which worksheet its data lives on?
Hi All
Is it possible through VBA to ask a chart for the name of the worksheet where it is sourceing its data? I have one worksheet with all my charts. Each chart refers to data on a seperate sheet - one per chart. I would like to loop through each ActiveSheet.ChartObjects and find the worksheet where the data lives - I then intend to update it based on user criteria. I cannot see how to acheive this through the object model. Is this possible? I suppose it may not be as a chart may have data from multiple worksheets. Thanks for any ideas in advance, Chrisso |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is it possible to ask a chart which worksheet its data lives on?
You can parse the series formula of each series to find where its data
resides. John Walkenbach has a class module that does the heavy lifting for you: http://www.j-walk.com/ss/excel/tips/tip83.htm Find the range containing a series' X or Y values, then determine the parent of that range. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chrisso" wrote in message ups.com... Hi All Is it possible through VBA to ask a chart for the name of the worksheet where it is sourceing its data? I have one worksheet with all my charts. Each chart refers to data on a seperate sheet - one per chart. I would like to loop through each ActiveSheet.ChartObjects and find the worksheet where the data lives - I then intend to update it based on user criteria. I cannot see how to acheive this through the object model. Is this possible? I suppose it may not be as a chart may have data from multiple worksheets. Thanks for any ideas in advance, Chrisso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring chart data from one worksheet to another | Charts and Charting in Excel | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
Moving chart data to the same worksheet | Charts and Charting in Excel | |||
HALF-LIVES FOR A CURVE | Charts and Charting in Excel | |||
How do i recover data in a worksheet that is still in a chart? | Excel Discussion (Misc queries) |