Forum Discussion
Excel template chart data percentage won't change
Hi there, this is my first post and I'm a complete amateur at Excel so bear with me please! Below are screenshots are my worksheet I used based on the template they had for personal budget. I use...
Well, let me just repeat the last paragraph from my response to RosieBenn
Just for the record, though, I've not used many templates myself--preferring to design my own--but have seen quite a few from other people posting questions here on this forum. And I have yet to see one that doesn't have quirks, odd problems, sometimes from hidden elements that are difficult to locate. They're not for the faint-hearted! My recommendation is to use templates like this as a jumping off point to create your own....
To go a step further, if you really want help, you need to provide more information. A cry for "Help!" doesn't give anybody anything to work with. So go back and read the rest of what I wrote--tell us what template (with a link, ideally) you're finding hard to work with, etc., etc., etc.
- Where is the template from, if I may ask? Is it a Microsoft template, or from some other source? If it's from Microsoft, I can see if there's somebody from the organization who can address it at its source.
My own assessment of it, frankly, is that it's not a very thoughtful or useful design in the first place.mathetes Hi John,
This exact same template came-up not too long ago. A person wanting to copy the budget sheets to be used in the next two months as well. And the problem was that the percentage chart wouldn't change with it.
I share your assessment that this is a bad template, but with some tweaks I could get to a working version for the other OP.
If it needs to be extended to cover more months, just repeat the steps I explained in the thread in the link below. It also contains a file with a working example for three months.
https://techcommunity.microsoft.com/t5/excel/copying-an-excel-sheet/m-p/4015388#M215174
- Thanks man. It works. Fantastic work. I appreciate your work. But i can see your template have only 3 months. Could you upload for me at leats with 12 months? Please
