Percent of increase each year
 

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 :(

Percent of increase each year
 

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


On Tue, 13 May 2008 09:09:01 -0700, Shayra
wrote:

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 :(

Percent of increase each year
 

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.

"Tushar Mehta (Microsoft MVP Excel 2000-2" wrote:

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


On Tue, 13 May 2008 09:09:01 -0700, Shayra
wrote:

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 :(