I am looking to have a cell value as part of the range that is plotte
in a chart, for example

=SERIES(,Sheet1!$A*$1*:$A$10,Sheet1!$B*$1*:$B$10,1)

I would like to replace *$1* (for both A and B with a value that i
entered in another cell (say D15). The value in D15 would be tied to
scroll bar.

Any help would be appreciated

--
Message posted from http://www.ExcelForum.com

Hi
have a look at the INDIRECT function. You may also have a look at
=SERIES(,INDIRECT("Sheet1!$A$" & D15 & ":$A$10"),INDIRECT("Sheet1!$B$"
& D15 & ":$B$10"),1)




--
Regards
Frank Kabel
Frankfurt, Germany


> I am looking to have a cell value as part of the range that is
plotted
> in a chart, for example
>
> =SERIES(,Sheet1!$A*$1*:$A$10,Sheet1!$B*$1*:$B$10,1)
>
> I would like to replace *$1* (for both A and B with a value that is
> entered in another cell (say D15). The value in D15 would be tied to
> a scroll bar.
>
> Any help would be appreciated.
>
>
> ---
> Message posted from http://www.ExcelForum.com/

Thanks for the quick response.

Now I am getting a
"That function is not valid" error

When I click OK it highlights the first INDIRECT

=SERIES(,*INDIRECT*("Sheet1!$A$" & D15
":$A$10"),INDIRECT("Sheet1!$B$"
& D15 & ":$B$10"),1

--
Message posted from http://www.ExcelForum.com

consider add a scrollbar from 'Control Toolbox' right click it to inser
this code:

Private Sub ScrollBar1_Change()
Worksheets("Sheet1").Range("D1").Value = ScrollBar1.Value
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C1:R"
Worksheets("Sheet1").Range("D1").Value & "C1"
ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C2:R"
Worksheets("Sheet1").Range("D1").Value & "C2"
End Sub




skelhorne wrote:
> *I am looking to have a cell value as part of the range that i
> plotted in a chart, for example
>
> =SERIES(,Sheet1!$A[B]$1*:$A$10,Sheet1!$B*$1*:$B$10,1)
>
> I would like to replace *$1* (for both A and B with a value that i
> entered in another cell (say D15). The value in D15 would be tied t
> a scroll bar but I don’t know the syntax or if this is eve
> possible.
>
> Any help would be appreciated. [/B

--
Message posted from http://www.ExcelForum.com

Frank -

Unfortunately one cannot embed any functions within the SERIES formula.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______


Frank Kabel wrote:

> Hi
> have a look at the INDIRECT function. You may also have a look at
> =SERIES(,INDIRECT("Sheet1!$A$" & D15 & ":$A$10"),INDIRECT("Sheet1!$B$"
> & D15 & ":$B$10"),1)
>
>
>
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
>
>>I am looking to have a cell value as part of the range that is
>
> plotted
>
>>in a chart, for example
>>
>>=SERIES(,Sheet1!$A*$1*:$A$10,Sheet1!$B*$1*:$B$10,1)
>>
>>I would like to replace *$1* (for both A and B with a value that is
>>entered in another cell (say D15). The value in D15 would be tied to
>>a scroll bar.
>>
>>Any help would be appreciated.
>>
>>
>>---
>>Message posted from http://www.ExcelForum.com/
>
>

Thanks Jon. That's not the answer I wanted to hear but at least I ca
stop wasting my time trying to figure it out

--
Message posted from http://www.ExcelForum.com

Don't discount "yusoon"'s answer. I have a more detailed description in
this article:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

skelhorne < wrote:

> Thanks Jon. That's not the answer I wanted to hear but at least I can
> stop wasting my time trying to figure it out.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>