General discussion

Locked

How to display Excel formula in a chart

By anejako ·
Is there a function within Excel where you can highlight a line on a
chart and Excel will determine the formula for the line?

I can see data values just fine, but I would like to see formulas.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to display Excel formula in a chart

by DKlippert In reply to How to display Excel form ...

Interesting idea. I think I've found what you're looking for:

www.j-walk.com/ss/excel/tips/tip83.htm

"When you select a series in a chart, its SERIES formula is displayed in the formula bar. The Formula property returns this formula as a string." John Walkenbach

Collapse -

How to display Excel formula in a chart

by DKlippert In reply to How to display Excel form ...

Scroll to the bottom of the page. John includes a spreadsheet to download with the code.

Collapse -

How to display Excel formula in a chart

by anejako In reply to How to display Excel form ...

Poster rated this answer

Collapse -

How to display Excel formula in a chart

by igp In reply to How to display Excel form ...

Sub FormulaChart()
Dim MyChart As New ChartSeries
With MyChart
Chart = Sheets(1).ChartObjects(1).Chart
ChartSeries = 1
If .XValuesType = "Range" Then
MsgBox .XValues.Address
ElseMsgBox .XValues
End If
End With
End Sub

Collapse -

How to display Excel formula in a chart

by anejako In reply to How to display Excel form ...

Poster rated this answer

Collapse -

How to display Excel formula in a chart

by anejako In reply to How to display Excel form ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums