graphing year on year combo chart

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,802
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.

1590721180357.png


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

2019​
2020​
Sum of Payment AmountCount of Payment Amount2Sum of Payment AmountCount 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?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,802
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

Well-known Member
Joined
Feb 5, 2003
Messages
1,802
so, now i get this:

1590723469811.png


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?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,961
Messages
5,627,866
Members
416,278
Latest member
CellHell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top