Forum Discussion
30-day rolling graph.
Dear community, This is the first time I am reaching out like this and I am stuck with something I cannot find the answer to with simple google and YouTube searches. I have a file of data that I ...
You can use dynamic named ranges for this purpose. Look at Formulas > Name Manager to see the definitions of the ones I created (XValues, AValues, etc.)
I'm not sure what charts you want, so I just created one, you can easily modify them or copy them.
The chart is a line chart with XValues as category axis values, and AValues as legend entries (series).
- Thank you very much, that is very close to what I had in mind! The technical bit is exactly what I needed, the layout was secondary. I'll play around with it and will try to create the others myself. Much appreciated!
