A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

extrapolating data from chart



 
 
Thread Tools Display Modes
  #1  
Old January 30th, 2006, 03:49 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old January 30th, 2006, 04: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



  #3  
Old January 31st, 2006, 08:28 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old January 31st, 2006, 11:40 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 07: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 04:36 PM


All times are GMT +1. The time now is 10:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.