Forum Discussion
Solved
weird chart type
I wanna ask, I wanna use this chart but it doesn't displayed the correct values can anyone explained?
- The issue is with the chart type, you currently are displaying a stacked line chart, so you're now looking at the cumulative value of the numbers. SO A displays correctly, but the line for B is the sum of A and B, line C is SUM(A,B,C) etc. change the chart type to a regular line chart to fix this.
JKPieterse wasn't it very obvious that chart doesn't show the correct value? my question is just that the value should displayed that way...
Yes it is obvious, but I'd like to know what is going on and for that I need a sample file.
JKPieterse ok. here's the file.
- The issue is with the chart type, you currently are displaying a stacked line chart, so you're now looking at the cumulative value of the numbers. SO A displays correctly, but the line for B is the sum of A and B, line C is SUM(A,B,C) etc. change the chart type to a regular line chart to fix this.
JKPieterse so that's the meaning of stacked charts?? phew... thanks for the explanation...