Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2014, 02:40 PM
edneco edneco is offline Graphic equation in a cell Windows 7 32bit Graphic equation in a cell Office 2007
Novice
Graphic equation in a cell
 
Join Date: Jun 2014
Posts: 12
edneco is on a distinguished road
Default Graphic equation in a cell

Hello everyone..... This is my first post here and Iīm not sure if this is the right place to put this question.....



I have a file connected to web and collect some values in a row. This row is conected to a graphic. More data I have, better is the tendency line..... Itīs not a estatic graphic, so the graphic equation is always changing when data is collected.

The most difficult part to me is that I need that graphic equation in a cell in a way that allow me to make some calculations with this equation.

I donīt know if itīs needed a VBA code or there is another way to do this.....

I must "warn" you that my knowledge about VBA code is minimum......

If some one can elucidate me on yhis, I thank you very much.......
Reply With Quote
  #2  
Old 06-08-2014, 07:43 AM
whatsup whatsup is offline Graphic equation in a cell Windows 7 64bit Graphic equation in a cell Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

With minimum knowledge of vba you will at least know where to put the code :
Code:
 
Sub GetFormula()
With Sheets(1)
    .Range("A1").Value = .ChartObjects(1).Chart.SeriesCollection(1).Trendlines(1).DataLabel.Text
End With
End Sub
Adjust the references to your convenience. The result is shown in the moment in cell A1
But that's only half way, you still will have to split the string to do further calculation. It's just to show you to get hold of the contents of the label.

Otherwise there are also ways to do the calculation directly in the sheet, but you didn't mention what kind of tendency you've got in use...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extend Label in a Graphic gexxy PowerPoint 0 04-11-2013 11:40 AM
background graphic removal taffyevo PowerPoint 0 08-16-2011 06:36 AM
Graphic equation in a cell Why copying a paragraph to an equation ends without equation format??? Jamal NUMAN Word 2 04-24-2011 06:18 AM
How to cut and paste a graphic to a different page in word.? soooty Drawing and Graphics 1 08-12-2010 11:17 AM
Graphic equation in a cell Graphic files do not appear in my document plt Drawing and Graphics 2 04-22-2009 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft