This is a problem for an expert in excel. If that is the case, I expect the solution to be obvious.
I need to graph data in excel and smooth out any kinks. The excel "Trend" formula accomplishes this goal BUT I need to first and last data points to be the actual data not data manipulated by the trend formula. If I just try and substitute the actual beginning and end data for the number supplied through the trend formula it creates very odd kinks.
The attached excel sheet illustrates the issue. The actual data is kinked. The smoothed data looks great but starts and ends on a different data point. I need the actual data points with a smooth curve.
25 Freelancer bieten im Durchschnitt $112 für diesen Job
To work quickly and quality is my top priority. I often ask many questions so that I fully understand your business [login to view URL] I have a project in my hands- I give my best.I am always honest
i understand well your project and as i'm expert in excel ,I'm an acountant and all my my work done using excel,i will do the task with high accurency and ontime.
I do this sort of work everyday for several key clients and also for outsourced companies. I would work with utmost dedication and the delivery would be done completely as per your expectation.