CHART HELP Percent of Increase

  • Thread starter Thread starter Shayra
  • Start date Start date
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.
 
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
 
Back
Top