Forum Discussion
RNNL21
May 24, 2021Copper Contributor
30 Day Rolling Graph - Part II
Dear Community, I recently reached out to all of you as I needed some help getting things going with rolling graphs in my report. Mr. HansVogelaar helped me set things up a little but I just can'...
HansVogelaar
May 24, 2021MVP
On Last30A:
Chart B: you have set a fixed range for the y-values, instead of the dynamic range that you have created correctly:
You should use =DataA!DValues
For chart C, you have set neither the x-values nor the y-values to a dynamic range.
The problems with chart D are similar.
For Last30B, you need to set up a series of defined names that refer to DataB. I have named them XValues2, AValues2, etc. Also add a name GValues2, needed for chart D.
Since row 3 is blank, the ranges need to start one row lower down.
See the attached version.
Then use these in the source of the charts.