graphing year on year combo chart

[ajm]

Hi all. i am graphing 2 years of payment volumes and number of applications for grants in a simple dual axis bar chart. Sum of payments are plotted on the primary vertical axis, months are across the horizontal axis, count of applications are on the secondary vertical axis.

my data is set up in a pivot table similar in set out to this:

	2019​		2020​
	Sum of Payment Amount	Count of Payment Amount2	Sum of Payment Amount	Count of Payment Amount2
Jul	15.745​	15​	8.717​	10​
Aug	17.1​	16​	8.722​	10​
Sep	13.36​	13​	7.64​	9​
Oct	14.175​	14​	8.505​	10​
Nov	12.405​	12​	7.75​	9​
Dec	9.877​	10​	7.6​	9​
Jan	7.699​	8​	5.34​	7​
Feb	7.982​	9​	7.455​	9​
Mar	9.705​	11​	8.89437​	11​
Apr	7.459​	8​	8.46​	10​
May	8.26​	10​
Jun	7.615​	9​

as we have only data until April this year, the amounts for May and June are blank. why does the count line for 2020 (purple) not drop to zero?

 

[ajm]

seems that the issue only arises because i used a pivot chart. If you run a normal chart of a copy of the data, there is no tail to the line. i can make a copy of the pivot in some blank space and run the chart off that if i have to.

 

[ajm]

so, now i get this:

Rather than the drop to zero for the last two months of the year, i would actually like to see the 2020 line end at April which is where the last count is. Can this be done?