extrapolating data from chart

[tricard]

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

 

[Jon Peltier]

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.aspx?scid=kb;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/
_______

 

[Tim Ricard]

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.aspx?scid=kb;en-us;300643

Though if you already have the data, this might be redundant.

- Jon
-------

Thank you very much for the help.

Tim

 

[Tushar Mehta]

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/microsoft.public.excel.programming/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