extrapolating data from chart

[[email protected]]

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...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/
_______

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[Tim Ricard]

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

[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/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 <[email protected]>,
[email protected] 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
>
>