#1
|
|||
|
|||
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....... |
#2
|
|||
|
|||
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 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... |
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 |
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 |