evileconboy
New Member
- Joined
- Mar 18, 2015
- Messages
- 3
I've got some data (5% in each column, unvarying, for 10 years).
I constructed a spark line to cover this data, and Excel, for some reason, has the sparkline showing crazy variability. There is literally no variability in this data. It's 5% precisely. When I re-copy the formulas, the sparkline shows correctly (a straight line). But when I hit F9 to recalculate, the sparkline changes back to a squiggly line with crazy variability.
Clearly there is something about where the sparkline is getting its data that I don't understand. I've re-done the sparkline from scratch in other places, to no avail. Does anyone know what's going on that would make a sparkline pointing to constant data show variability?![Mad :mad: :mad:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I constructed a spark line to cover this data, and Excel, for some reason, has the sparkline showing crazy variability. There is literally no variability in this data. It's 5% precisely. When I re-copy the formulas, the sparkline shows correctly (a straight line). But when I hit F9 to recalculate, the sparkline changes back to a squiggly line with crazy variability.
Clearly there is something about where the sparkline is getting its data that I don't understand. I've re-done the sparkline from scratch in other places, to no avail. Does anyone know what's going on that would make a sparkline pointing to constant data show variability?