Percent of increase each year

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shayra - 13 May 2008 17:09 GMT

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

Reply to this Message

Tushar Mehta (Microsoft MVP Excel 2000-2008) - 13 May 2008 17:25 GMT

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

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

Reply to this Message

Shayra - 13 May 2008 18:21 GMT

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.
[quoted text clipped - 4 lines]
> >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 :(

Reply to this Message

Rate this thread: