Forum Discussion

Waceks's avatar
Waceks
Copper Contributor
Jun 06, 2019
Solved

Dynamic range of data for graph

After many days of trials I must ask for help. I need to create a graph from range of data, which first cell is defined but the last cell changes based on value in another cell. All data is in one c...
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Jun 07, 2019

    Waceks 

    In the attached file, I entered "=DynamicSeriesValues!SeriesValues" in the Series Values box of the Edit Series tab. SeriesValues is a named range with this formula: 

    =Arkusz1!$C$3:INDEX(Arkusz1!$C:$C,Arkusz1!$A$3+2)

    Please modify the value in A3 to see the effect of the dynamic range on the chart. 

Waceks's avatar
Waceks
Copper Contributor
Jun 07, 2019

TwifooThank you for your answer, but this is not the problem I have. Such formula I wrote already in cell F4.

The problem is how to use it in graph. The range like "=Sheet1!$C$3:$C$32" is OK but "=Sheet1!$C$3:ADDRESS(A3+2;3)" doesn't work.

Twifoo's avatar
Twifoo
Silver Contributor
Jun 07, 2019

Waceks 

In the attached file, I entered "=DynamicSeriesValues!SeriesValues" in the Series Values box of the Edit Series tab. SeriesValues is a named range with this formula: 

=Arkusz1!$C$3:INDEX(Arkusz1!$C:$C,Arkusz1!$A$3+2)

Please modify the value in A3 to see the effect of the dynamic range on the chart. 

  • Waceks's avatar
    Waceks
    Copper Contributor
    Jun 07, 2019

    TwifooIt is exactly what I needed. Thank you very much.

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Jun 07, 2019
      You're very much welcome!

Resources