Graphic equation in a cell

whatsup · #1 06-08-2014, 07:43 AM

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

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
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 files do not appear in my document	plt	Drawing and Graphics	2	04-22-2009 09:58 AM