SOLVED

weird chart type

Copper Contributor

I wanna ask, I wanna use this chart

clipboard_image_0.png

 

but it doesn't displayed the correct values

clipboard_image_2.png

 

clipboard_image_3.png

 

can anyone explained?

6 Replies
Can you upload a sample file which shows the problem?

@Jan Karel Pieterse 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.

@Jan Karel Pieterse ok. here's the file.

best response confirmed by chippzanuff (Copper Contributor)
Solution
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.

@Jan Karel Pieterse so that's the meaning of stacked charts?? phew... thanks for the explanation...

1 best response

Accepted Solutions
best response confirmed by chippzanuff (Copper Contributor)
Solution
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.

View solution in original post