Forum Discussion
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...
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.
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.
