antaeusguy
Board Regular
- Joined
- Mar 8, 2010
- Messages
- 81
I've created a graph which the series link to a range with values.
If the values changes, the graph series will also change.
However, I forgot what I did I do the graph, and the series became hard coded with values.
Linked to ranges:
=SERIES("Previous year",Dashboard!$C$99:$C$110,Dashboard!$D$99:$D$110,1)
Hard-coded:
=SERIES("Previous year",Dashboard!$C$99:$C$110,{13170.0559978919,11302.4710116538,9805,29005,8851,10429,10207,10777,12370,12265,12933,14758},1)
Does anyone know how did the graph series changed from linked ranges to hard-coded values? So that I will be aware of my actions.
If the values changes, the graph series will also change.
However, I forgot what I did I do the graph, and the series became hard coded with values.
Linked to ranges:
=SERIES("Previous year",Dashboard!$C$99:$C$110,Dashboard!$D$99:$D$110,1)
Hard-coded:
=SERIES("Previous year",Dashboard!$C$99:$C$110,{13170.0559978919,11302.4710116538,9805,29005,8851,10429,10207,10777,12370,12265,12933,14758},1)
Does anyone know how did the graph series changed from linked ranges to hard-coded values? So that I will be aware of my actions.