I do not know exactly what I need but I know I want good charts to graphically represent the data in the attached file. As an Excel expert, you will likely see the data and know how to run with it. I do not want to be very hands-on in the process.
I need someone to create a file that I can use to add stats to it monthly for charting. Right now I keep everything in the attached Excel file. My preference would be for Sheet 1 to have the different charts that I can review. Something like a dashboard. The charts need to update automatically as I add new data each month. The data will come from Sheet 2 or some other sheet.
Data is collected once a month. Originally I only stored the Item Name and Quantity (Count). As time went on, I started collecting more data.
As time has passed, more items have been added to the inventory. That is the reason for there being blank values in some locations.
The values I am most interested in Charting are...
I want the Unique and Count values to also show the % of growth over the previous month. If the dashboard allows, allow me to set the option to compare to; Last Month, 3 Months Ago, 6 Months Ago, 12 Months Ago.
Right now there are only 40 Items but this will continue to increase (likely no more than 50).
If you ask questions, do not be too technical.
My goal is to quickly find someone that can do this and allow them to run with it without being asked a lot of questions.
FYI - The values I have provided "Item 1, Item 2" are not the real values. I am unable to share the real name of the values but once the file is in my possession, I'll revise it. So whatever your solution is, I need to be able to easily modify the item names.
I only want to hire someone that pay attention to detail. Because of that, I will only consider bids that start with this text "I read the details and reviewed the Excel file". That way I know you read it all.
30 freelancers estão ofertando em média $61 para esse trabalho
Hi, I have understand the project requirement & interested to make dashboard with nice charts and graph for this project. Please send a message so we can discuss more & start the project. Thanks.
"I read the details and reviewed the Excel file" Hi, there I read the description of the task. It is matching my expertise. I am willing to accomplish it. Please open chat for further discussion thanks
I have a lot of experience to makes statics data more easy and beautiful by adding graphics Relevant Skills and Experience good knowledge of Ms word, excel and know how to use SPS software