Excel Formulas to Existing Report

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

I have an existing excel document with raw data linking into a report (a range of graphs).

When I report each month ( add the new column of data for the new month), I have to go through each graph and re-select the new range and relevant fields.

I believe you can resolve this through defining names etc, however I don't have the time to set this all up.

I would like it set up so that when I add a new column with the latest month's data, the graph automatically updates.

Excel

Project ID: #18724757

About the project

53 proposals Remote project Active 5 years ago

53 freelancers are bidding on average $118 for this job

cgullapalli

Hi, I am good at Excel and Dynamic graph creation. Please share the file to review the existing setup to get the scope of work (number of graphs). Looking forward to discuss further in the chat and start working More

$100 AUD in 1 day
(855 Reviews)
8.0
asin1987

Dear Employer, I understand your graph issue and I will do the job for you. Please message me and share some details which I can go through. Do try me once!! :) Thanks and Regards, Ash

$200 AUD in 4 days
(183 Reviews)
7.6
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have a graph in Excel updated when you add a new column of data. I can do this with a More

$100 AUD in 1 day
(219 Reviews)
7.4
tiaratechies

Hello, as a team of advanced excel experts, I can provide you the sheet that is perfect for your reports, can we discuss about this in chat.

$250 AUD in 1 day
(51 Reviews)
6.9
priyal1997

Dear Sir/Madam, I am an expert in advanced excel skills and can develop a perfect dynamic model for this purpose. I have done lots of similar excel models for businesses across the world including some big AUS compan More

$60 AUD in 0 days
(187 Reviews)
6.8
TonmoyRoy111

Dear client I can help you in this project. I know exactly what you want and what i need to do. Please trust me skills and contact me. Waiting to hear from you. Roy

$100 AUD in 1 day
(341 Reviews)
6.9
seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I might have a few question to discuss so I need you to send a message on chat.

$100 AUD in 3 days
(80 Reviews)
6.4
macroPOL

Hello, I am Excel and VBA expert. Could you provide the file? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan

$100 AUD in 4 days
(93 Reviews)
6.0
nvchien94

Hello there, I am an Excel macro coder and I can give you a macro to update your data. U will click the button after update new data and your chart will be automatic select new number. Contact me and I will start r More

$30 AUD in 0 days
(148 Reviews)
5.9
pm9887

Hi, As per given details Its data entry and excel related task. I have great experience in all kind of backend support. I am good in lead generation, internet research, market research, data entry, data processing and More

$80 AUD in 3 days
(62 Reviews)
5.6
khurram1984

Hi,. i am an affiliate chartered accountant and a professional excel expert since 2009. i have hands on experience in creating templates, project reports, etc. completely automated with minimum manual entries. i have r More

$85 AUD in 2 days
(48 Reviews)
5.7
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam More

$65 AUD in 3 days
(41 Reviews)
5.6
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

$110 AUD in 1 day
(65 Reviews)
5.6
archanaoswal

I have excellent command on MS Excel and can write a code to update the graph automatically when a new column is inserted. I have completed complex projects in Excel before . For instance - Built a POS and inventory More

$100 AUD in 2 days
(78 Reviews)
5.7
afenache

Hi, I can write the needed formulas to update the data that will populate your charts when you add new data on your data set. Best regards, Florin Enache

$130 AUD in 2 days
(22 Reviews)
5.3
dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project More

$100 AUD in 3 days
(44 Reviews)
5.1
Ashisjena2015

Hi, I am an advanced excel expert having more than experience of ten years in excel related work. Please check my profile for more reviews and discuss in detail over chat right now.

$100 AUD in 1 day
(36 Reviews)
5.1
AhmedMarzoq

Hello sir I can used very advance methods and formulas and built data to can easy insert update month and graph will update automatic or we need restructure file to be easy in update all of these depend on you detai More

$45 AUD in 1 day
(22 Reviews)
4.9
GopalJp

Hi, No worries! I can help you on your project Excel formulas to existing report. I am an expert in Microsoft Excel including VBA or Macros. I will confirm your graph properties to automate the range of data once th More

$50 AUD in 3 days
(14 Reviews)
4.6
kelvinm094

Dear client? I highly value professionalism and hold myself strictly accountable to represent my client’s work. I aim to form a long-term working relationship. For 3 years I’ve worked as a data analyst and so I am ac More

$79 AUD in 2 days
(5 Reviews)
3.3