Hi, I am currently working on a spreadsheet that calculates report figures including weekly and yearly totals of referrals coming in to the business.
I have used a template from the excel suggestions however the calculations in the graph section are not how I want them to be. I want the graph to show each column as a separate calculation. e.g. the weekly leads to be calculated in purple. the total leads to be highlighted in another colour and so on with the other columns. The algorithms are currently adding up everything as an average of ALL columns combined (even though they are colour coordinated).
I also want the percentage to be related to the 'total leads' only.
Also, can you correct the 'weekly leads' to add on top of the total leads. as every week the figures will change, it would work better if the 'total leads' is automatically calculating the full figure of leads added.
15 freelancer đang chào giá trung bình $27 cho công việc này
I can definitely help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro.