Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Axis label that corresponds to cell
I have an interactive graph which graphs data from a set column. This column changes depending on what is selected on a list selector. I was wondering if there is a way to label the y axis whatever was in, say cell AD11. I was hoping that that this would be something easy that I could write into the excel chart wizard, like =$AD$11, but it is not. Any help would be appreciated. -- pete3589 ------------------------------------------------------------------------ pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402 View this thread: http://www.excelforum.com/showthread...hreadid=483691 |
#2
|
|||
|
|||
Axis label that corresponds to cell
Assuming the chart is an embeded object on the sheet and is called
"Chart 1" then this will change the Y axis title every time AD11 is changed: Private Sub Worksheet_Change(ByVal Target As Range) Dim chrt As ChartObject Dim axs As AxisTitle If Target.Address = "$AD$11" Then Set chrt = Me.ChartObjects("Chart 1") Set axs = chrt.Chart.Axes(xlValue).AxisTitle axs.Characters.Text = Target.Value End If End Sub This is worksheet event code. Right click the sheet tab, select View Code and paste the code in there. Hope this helps Rowan pete3589 wrote: I have an interactive graph which graphs data from a set column. This column changes depending on what is selected on a list selector. I was wondering if there is a way to label the y axis whatever was in, say cell AD11. I was hoping that that this would be something easy that I could write into the excel chart wizard, like =$AD$11, but it is not. Any help would be appreciated. |
#3
|
|||
|
|||
Axis label that corresponds to cell
Yes it did. Thank you Rowan -- pete3589 ------------------------------------------------------------------------ pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402 View this thread: http://www.excelforum.com/showthread...hreadid=483691 |
#4
|
|||
|
|||
Axis label that corresponds to cell
You're welcome.
pete3589 wrote: Yes it did. Thank you Rowan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Link a cell to min & max box for Value (X) axis scale? | Charts and Charting in Excel | |||
Format chart axis by inputting data in a cell | Charts and Charting in Excel | |||
Excel graph y axis label cut | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel |