If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
extrapolating data from chart
Good evening all,
Here is a weird question: I have created a chart from given source points but I need to extract some of the data from this chart to make an approximation on other data. Is there any way to write a VBA script or simply select a command that allows you to extrapolate chart data and place the desired extrapolated data into destination cells? Thanks for the help Tim |
#2
|
|||
|
|||
extrapolating data from chart
This article from Microsoft's Knowledge Base has a macro to extract all the
data from a chart. You could use it, then remove the data you don't care about: Macro to Extract Data from a Chart http://support.microsoft.com/default...b;en-us;300643 Though if you already have the data, this might be redundant. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote in message oups.com... Good evening all, Here is a weird question: I have created a chart from given source points but I need to extract some of the data from this chart to make an approximation on other data. Is there any way to write a VBA script or simply select a command that allows you to extrapolate chart data and place the desired extrapolated data into destination cells? Thanks for the help Tim |
#3
|
|||
|
|||
extrapolating data from chart
Jon Peltier wrote: This article from Microsoft's Knowledge Base has a macro to extract all the data from a chart. You could use it, then remove the data you don't care about: Macro to Extract Data from a Chart http://support.microsoft.com/default...b;en-us;300643 Though if you already have the data, this might be redundant. - Jon ------- Thank you very much for the help. Tim |
#4
|
|||
|
|||
extrapolating data from chart
I am not sure how that article helps you since it doesn't address the issue
of extrapolating data. You may want to look at http://groups.google.com/group/micro...ing/msg/d7f416 bb00302586?dmode=source&hl=en -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... Jon Peltier wrote: This article from Microsoft's Knowledge Base has a macro to extract all the data from a chart. You could use it, then remove the data you don't care about: Macro to Extract Data from a Chart http://support.microsoft.com/default...b;en-us;300643 Though if you already have the data, this might be redundant. - Jon ------- Thank you very much for the help. Tim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
charts lose data | Steve | Powerpoint | 0 | January 28th, 2005 06:13 PM |
format in MS Access chart data table | Yolanda | General Discussion | 0 | September 19th, 2004 10:47 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Help with Data (Table) below my chart | Jon Peltier | Charts and Charting | 0 | November 20th, 2003 03:36 PM |