PivotChart - financingproblem

[LukasBe]

Hello everybody.

Is there any way to simplify my current table with PivotCharts?
I do have a big table (i added some screenshots how i used to solve the problem atm) with a lot of machines. These machines are all paid per month due a specific date. I do have a amount X for financing per month. I need to know when i have enough capacity to buy a new machine and how much i spend at a specfic month in the future.

I have tried almost everything to solve this problem with pivot charts, but it doesn't work at all. :-( With my current solution it takes forever when i bought a new machine.

Can anybody help me?
Thanks a lot!

Lukas

[Pepe Le Mokko]

Hi and welcome
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.