View Single Post
  #2  
Old January 30th, 2006, 03:23 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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