Forum Discussion

chippzanuff's avatar
chippzanuff
Copper Contributor
Dec 13, 2019
Solved

weird chart type

I wanna ask, I wanna use this chart   but it doesn't displayed the correct values     can anyone explained?
Charting
excel
  • JKPieterse's avatar
    JKPieterse
    Dec 19, 2019
    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's avatar
JKPieterse
Silver Contributor
Dec 13, 2019
Can you upload a sample file which shows the problem?
  • chippzanuff's avatar
    chippzanuff
    Copper Contributor
    Dec 14, 2019

    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...

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Dec 14, 2019
      Yes it is obvious, but I'd like to know what is going on and for that I need a sample file.

Resources