Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paolojolly
Creator
Creator

accumulated line chart starting from zero

Hi everyone,

in a line chart I have to compare weekly comulative sales of two customers over the years
If i use only one dimension

=IF(DATA_RIF_DOC > makedate(year(AddYears(vDataFin, -2)), 1, 1),
WeekDualTC
)

lines starts from zero values

If I add another dimension
=IF(DATA_RIF_DOC > makedate(year(AddYears(vDataFin, -2)), 1, 1),
CD_CLIENTE &'-'& YEAR(DATA_RIF_DOC)
)

lines no longer start from zero

I have to add the second dimension because I have to see the data of the two customers over the years

Can someone help me?

Thanks,

Labels (2)
2 Replies
jwjackso
Specialist III
Specialist III

It is still starts at zero, the problem is scale.  The first dimension goes from 0 to 21, the second dimension starts around 500.  If you very carefully put the cursor over the line near zero, you will see the first dimension.  see image.

scale.PNG

paolojolly
Creator
Creator
Author

Thanks, maybe I explained myself wrongly

I need to arrive at a result like the following 

finale result.png

 

in which chart lines start from x and y zero value  (see the red lines)

It's possible to do it?
Thanks again