Percent of increase each year

[Shayra]

hello, I want to create a bar or line chart that shows the percent of
increase in our sales but no values. We want to give a corporate overview, on
average each year we've been producing 15, 16, 17% more GP annually. I want
to show this growth without showing the amount of money we made. Our figures
date back 2004-2008. How can I do this? Im using Excel 2007

 

[Tushar Mehta (Microsoft MVP Excel 2000-2008)]

In a separate column, calculate the percentage increase. Now, plot
the year column and this new column.

 

[Shayra]

Right this sort of works, however it is plotting the years on the vertical
axis and then 1,2,3,4,5 on the horizontal axis. The bars show appropriately
though

Can I have the years on the horizontal and the percentage on the verticle
axis? i've interchanging the column locations and it still does not work.