I have a table I want to convert into a graph (bar-graph or line-graph)
The first column has fixed values. Twenty different values are simulated for these fixed values and kept in the next columns. I want to plot a graph of the fixed column against all the different twenty simulated columns.
How do I go about it?
V1 V2 V3 V4 V5 100 16 11 -6 1 120 -17 -12 7 -2 140 18 13 -8 3 150 -19 -14 9 -4 210 20 15 -10 -5
Actually, my table looks like the one above. The first column V1 represents Premiums charged by an insurance company,say last year (for 5 policyholders/policies) After critical analysis of the portfolio, the company decides to increase or decrease the premium amount for some of the customers. However, the company does not know exactly by how much it should increase of decrease the premiums for fear that it would lose customers. For this reason, four different scenarios/simulations are considered which are represented by the next four columns(V2 through V5) respectively.
Now the task is to plot the premium amounts in V1 against these four different scenarios(bar-graph or line-graph; I think bar will be better).
And my question is can this be done on one graph/at once? If yes, how shoul I go about it? Or do I have to plot the premium against each column separately?
In fact, I have spent the whole of yesterday and today on this but I have not been able to get the desired result.
Someone gave me an answer to try.And I am going to do that because it has given me an idea and I am very thankful to the one!
Many thanks to everyone for their help