CHART HELP Percent of Increase

S

Shayra

PLEASE HELP

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

I would like to show the years on the horizontal axis and the percents on
the verical axis so that you can see the consistent upward slope each year.
???

I've been inputting the years in one column and the corresponding % of
increase in the next column but when I plot the chart it places the years on
the vertical and 1,2,3,4,5 on the x axis I don't even know where it's pulling
these numbers from.
 
J

Jon Peltier

Start with a new sheet. Leave cell A1 blank. Put the years in A2 to A6, or
down as far as you need. Enter a label like "Increase" in cell B1, and enter
the percentage increases in B2:B6 or as far down as you need. Select this
range and insert a line or column chart.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top