Hello guys I need the support of the experts, I have been looking for a similar question and could not find ideas for the following issue:
I have something like this:
Column A Column B Column C
1 Material $281.34 65.9%
2 Labor $34.02 8.0%
3 OH $27.76 6.5%
4 Depreciation $4.97 1.2%
5 Others $35.09 8.2%
6 Margin $43.52 10.2%
_____________________________
7 Total $426.69 100.0%
75 Pie Chart b75:c86 (Pie chart based in A1:A6,C1:C6)
Columns B & C contains formulas, every time that I change my inputs the formulas are updated.
I have a button that copy both columns, then insert them to the left as only values and leave the columns with formulas always to the right ready to add new inputs.
My issue is because the pie chart is bellow, and every time that I press the button the pie chart always contain the initial data (A1:A6,C1:C6)
And I' d like an additional code to auto select of this way:
- Initial Pie Chart In B75:C86 selecting data from A1:A6,C1:C6 (letter arial narrow size 8, no title)
After pressing a button the columns B:D are copied and pasted as values to the left, and new columns E:G are left to the right with formulas
- 2nd pie chart In E75:F86 selecting data from A1:A6,F1:F6 (letter arial narrow size 8, no title)
After pressing a button the columns E:G are copied and pasted as values to the left, and new columns H:J are left to the right with formulas
- 3rd pie chart In H75:I86 selecting data from A1:A6,I1:I6 (letter arial narrow size 8, no title)
Repeat the loop n times that I press the button.
I'd appreciate your support very much.
Bookmarks