Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Percent increase | Excel Discussion (Misc queries) | |||
Percent increase | Excel Worksheet Functions | |||
Percent increase in excel | New Users to Excel | |||
Percent Increase | Excel Discussion (Misc queries) | |||
calculate percent increase | Excel Discussion (Misc queries) |