Forum Discussion
Excel template chart data percentage won't change
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.
Here is the link
https://1drv.ms/x/c/5c8286070b533ec0/EX9E6xvINehDr09RnOBabyIBdF72U67QtkEm4k2vsVyu-Q
- 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
