chart editing in excel via vba
Budget: $30 – $250 NZD
we have excel sheet that via vba auto creates new data columns.
ie column C and D are property 1 and when we create a new property we populate E and F with that new props data. as lower down in column C and D we have charts (2 of them) for property 1, when we copy columns C and D into E and F the charts should copy as well (you can resize property 1 chart so it fits cleanly inside columns C and D). Then we need you to via VBA ensure the charts are using correct data(for teh new columns) and set titles (ie property 2 and 3 etc). this will be 2-3 hours vba testing etc.
ie column C and D are property 1 and when we create a new property we populate E and F with that new props data. as lower down in column C and D we have charts (2 of them) for property 1, when we copy columns C and D into E and F the charts should copy as well (you can resize property 1 chart so it fits cleanly inside columns C and D). Then we need you to via VBA ensure the charts are using correct data(for teh new columns) and set titles (ie property 2 and 3 etc). this will be 2-3 hours vba testing etc.