Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to return the data a chart is based on
Anone know of an method in VBA which will return the data series an
existing graph or chart is based on? I cannot I find any code to return the data series that a chart is based on. (i.e. return "C4:C7"). It seems an obvious thing to want to do but ... Andrew --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to return the data a chart is based on
See John Walkenbach's discussion of this:
http://j-walk.com/ss/excel/tips/tip83.htm A Class Module to Manipulate a Chart SERIES -- Regards. Tom Ogilvy dracstorey wrote in message ... Anone know of an method in VBA which will return the data series an existing graph or chart is based on? I cannot I find any code to return the data series that a chart is based on. (i.e. return "C4:C7"). It seems an obvious thing to want to do but ... Andrew --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to return the data a chart is based on
Many thanks Tom. I'm glad he says there is a serious flaw (I thought I
was going mad!). I will try his code and hopefully it will solve the problem. Thanks again Andrew --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to return the data a chart is based on
Problem nearly solved. I have very nearly integerated the code into
mine. Just a couple of bugs for me to deal with but therange is indeed returned! Many thanks Andrew --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Return Corresponding Value Based on Comparing Two Sheets of Data | Excel Worksheet Functions | |||
Return an array of data based on range of date | Excel Worksheet Functions | |||
HOW ?Excel chart auto insert /populate a code based on date | New Users to Excel | |||
have a cell return one of severl lists based on data from another | Excel Discussion (Misc queries) |