Suppose x axis has 4values, let’s say 2 4 7 10, and y axis has 4 corresponding values, let’s say it’s same like x axis 2 4 7 10, then the graph will be a straight line. When x is 15, we can assume y is also 15. If I had to draw the graph manually, I could just draw a straight line without knowing x or y beyond x=15.
Basically I’m using what I know and extending it to what I don’t know.
The nature of the graph will depend on the values of the Catagory Axix and the Value Axis., and also the type of graphical representation you have chosen.
It seems from your statements that you are looking for a Line graph.Now if the values for your Catagory Axis and the Value Axis forms a straight line , that will obviously bee shown on your graph.
Also look at the Interpolation() function - I think it fills in gaps between values and has a couple of modes to control how the ‘fill in’ numbers are generated with respect to the ‘real’ numbers.
So in other words u wanan base base your future trend based of your cureent numbers…so in a period of time if you revenue is increasing by 1 % you want your future resulkts to increase by that factor. is that so ?