Calculate item percentage span across a vertical line that equals to 100%
$10 USD
Paid on delivery
I have a graph with an Y-axis that goes from 0-140 (from bottom to top).
The 0-140 on the Y-axis represents the graph 100% in height. This means that 20 on the Y-axis equals to 12,5% of the graph height.
Lets assume I need to define a bar on this graph that on the Y-axis equals to 70 (which would be 50% of the graph height) or 105 .
How would I go about calculating what the Y-axis numbers would convert to in terms of graph percentage height?
Project ID: #8734443
About the project
23 freelancers are bidding on average $15 for this job
Dear client, I can accomplish the job for you. I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Ki More
we can do this in excel quickly I am mostly online. Just drop me a message so that we can discuss further about pricing and job details.
I am an accurate and reliable business/Accounting/finance Analyst. I am a proficient business expert with over eight years writing experience. I possess exceptional skills in writing case studies, essay, literature, re More
Hello, I am Faheem, I am a lecturer in Federal Urdu University Pakistan. I have done masters in Applied Mathematics and currently doing Ph.D. in Mathematics from Massey University Auckland. I can help you in this More
Hi I can help you with it. Please award this project to me. Looking forward to your reply. Thanks.
x% = y*100/140 so y = x%*1.4 I think this should help. Let me know if there is any more complication. Because this problem seems pretty straight forward.
how about (105/140) x100. This should be percentage based on height. Do you have the graph so I can have a look. Thanks
It is simple. Precentage = number of Y-axis / total number of Y-axis. Example: 105/140=0.75 in decimal. Or in percentage it will be 75.
I am good at explaining things .specially maths .that's what I do and that's what I love . see my work first and I am sure you would love to hire me every time
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. Good luck and succeed in this project.
Might you be opposed to expanding your question within the message feature of the website. Your intentions are not yet known from this description.
I can provide you with a formula to compute the graph percentage height given the value of Y and an explanation how it works.
I am a student at the College of Engineering study mathematics and statistics can help you in this task
Hi, I am a licensed civil engineer for 5 years and I will able to make your calculation be very accurate within ONE HOUR. Please don't hesitate to ask me even more questions with relates to the percentage in this gr More