CHART HELP Percent of Increase
 

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.

CHART HELP Percent of Increase
 

Use the Scatter chart type...

"Shayra" wrote:

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.

CHART HELP Percent of Increase
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Shayra" wrote in message
...
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.