I have a chart that should have a recommended line going through it. I would normally do this by having a "recommended" value for every value I chart. Is it possible to have a formula that repeats a bunch of values so that I don't actually have to maintain a list of "recommended" values? Here's a screenshot example
In my head it works like: =MakeArray(2.23, 7)
where 2.23 is the value and 7 is the number of repetitions. Then I could assign that to the series and not actually have to maintain another series of data that I don't actually care about.