LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percent increase buzy lizzy Excel Discussion (Misc queries) 2 September 14th 05 07:38 PM
Percent increase lledcp Excel Worksheet Functions 3 March 14th 05 08:11 PM
Percent increase in excel Aiko New Users to Excel 3 February 21st 05 12:33 PM
Percent Increase woody Excel Discussion (Misc queries) 2 December 27th 04 05:25 PM
calculate percent increase vlro Excel Discussion (Misc queries) 1 December 1st 04 02:35 PM


All times are GMT +1. The time now is 01:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"