Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable for Y values in chart
On my Bias chart, under Source Data, Series, my Y values =Correlations!
$D$8:$D$59 Is there a way to make the ending location ($D$59) a variable? I want the Y values ending location read from a cell entered by the user. So, let say, in cell C16, I want my user to enter the ending cell for the Y values they want to use for the Bias chart. Therefore, cell C16 would have D59 entered by the user. Thanks Don |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable for Y values in chart
Use a dynamic range name with a Refersto value of
=OFFSET(Sheet1!$D$8,,,$C$16,1) and refer to the name in the chart source data. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Don Barton" wrote in message ... On my Bias chart, under Source Data, Series, my Y values =Correlations! $D$8:$D$59 Is there a way to make the ending location ($D$59) a variable? I want the Y values ending location read from a cell entered by the user. So, let say, in cell C16, I want my user to enter the ending cell for the Y values they want to use for the Bias chart. Therefore, cell C16 would have D59 entered by the user. Thanks Don |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
variable for Y values in chart
On Jan 8, 10:26*am, "Bob Phillips" wrote:
Use a dynamic range name with a Refersto value of =OFFSET(Sheet1!$D$8,,,$C$16,1) and refer to the name in the chart source data. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Thanks Bob db |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing variable values to userform control | Excel Discussion (Misc queries) | |||
Calculating values in two columns based on a variable | Excel Discussion (Misc queries) | |||
SUM formula - using variable values | Excel Worksheet Functions | |||
Maintaining VBA variable values | Excel Discussion (Misc queries) | |||
Variable values in Index function | Excel Worksheet Functions |