Percent of increase each year

  • Thread starter Thread starter Shayra
  • Start date Start date
S

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 :(
 
In a separate column, calculate the percentage increase. Now, plot
the year column and this new column.
 
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.
 
Back
Top