I'm trying to create a logarithmic bar chart on Visio. Using Visio's coordinate system, I defined the following values for $f(x)$:
- $$f(0) = 200,000$$
- $$f(10) = 341,248$$
- $$f(100) = 482,496$$
- $$f(1000) = 623,744$$
- $$f(10000) = 764,992$$
- $$f(100,000) = 906,240$$
I've spent the weekend trying to figure out how I can define a function that maintains the defined values relationship. I'm stuck.
What are the steps to determining a function that will give me these values? I want to be able to plug-in, say, f(30) and the resulting value is a coordinate value on my Visio project that I can just type-in easily to position the individual bar charts.
Since this is not a Visio specific question, I figured I'd ask here because I want to understand the process of how you all go about solving this type of problem.
Thank you!
Your data fit perfectly to $f(n)=200,000+141,248\log_{10}n$ as long as the argument of the first data point is $n=1$ instead of $n=0$.