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.


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

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