Chart Percentage Of Numbers Above Zero

Oct 2, 2008

I have several line graphs produced in excel. The X axis represents time (but is actually is just a 'general' number) and the Y Axis is a number .

The Y Axis generally varies from -10 to +10. I want to work out the percentage of time where the graph is in + and -.

If it makes it easier to know, the data will always change by +1,-1,+0.25,-0.25 or 0.

If this is possible i would then like to have a formula/or however it is possilbe, to work out +,- and neutral (0).
I have also attached a graph for a viewable example.

View 6 Replies


ADVERTISEMENT

Column Chart With Line Chart And Percentage?

Sep 15, 2014

In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also.

View 3 Replies View Related

Pie Chart Percentage Calculation Incorrect

Aug 21, 2013

This is so simple, yet Excel doesn't give the correct value. So, here you go, I only have 2 Cells and 2 Labels. One Label for one Number and the other Label for the other Number.

For the Pie Chart I chose Cells:

Cell B36 with the number $54288
Cell B39 with the number $166113

By simply viewing this one can see one of the Percentages should be around 33% and the other 66%. However, Excel gives it a Percentage of 25% and 75%.

How can I get the correct values?

View 2 Replies View Related

Incorrect Percentage On Pivot Chart

Oct 20, 2007

If I simply publish the pivot chart, the correct percent values are displayed on the y-axis. However, when I publish it with the interactivty option, the percent values are wrong. For example, the actual value is supposed to be 13.7% but graph shows 46496000.00%. The other oddity is that the table published in interactive mode has the correct values.

View 3 Replies View Related

Excel 2010 :: Create Percentage Bar Chart?

Mar 19, 2013

Im looking to create a bar chart in Excel 2010 where the totalnumber of widgets is 33 and the number produced so far is 11. The bar chart would be a single bar that represents the percentage complete (33%) with the chart maximum range being 100% which would represent the number 38.

Ive included a mock up example of what the data and chart would look like

View 3 Replies View Related

Pie Chart To Graph Percentage Of Total Expenses

Jun 20, 2008

when you open up the file please ignore everything above the blue bar. That was the old data which was arranged wrong. I have actually figured a lot of this out but i am stuck. The graph is set up so when you click on the drop down menu (F26) it changes the graph to the relevant data. Now the bottom graph is currently graphing the Months Expense1 as a total of all Expense1. So January Expense1 was $100 so its 26% of all Expense1. and when you click on the drop down button you can changed the data to Expense2 and the graph changes. YAY ok thats cool. However, thats not what i want. I want the pie chart to be graphing the expenses as a percentage of total Expenses. So the drop down menu would be of the months instead of the expenses.

I have changed that with relative ease, but I cant get the data to graph how i want it to.

I have been using OFFSET() formula and the define name manager to set up the previous graph. You can easily look at the formulas i have used instead of me trying to explain everything. Please help. This is the test bed for a budgeting spread sheet I am working on.

if you can help me out that would be great.. Please try not to use Macros because i dont understand them all that well and I need to take what is done in this spreadsheet and learn from it and change it so it works when are thre 10 expenses.

View 9 Replies View Related

X Axis In Pivot Chart Shows Decimal Than Percentage

Sep 15, 2014

I had created a pivot table and pivot chart for the data, the pivot table shows the row label's as percentages which is correct, but it when comes to the pivot chart it shows it as decimal, for example a 10% shows 0.1, I tried of formatting the x axis and choose percentages but it doesn't want to change.

View 6 Replies View Related

Conditional Formatting Percentage Axis For Thermometer Chart?

Jun 11, 2014

I currently have a thermometer chart in Excel 2013 that I set up with percentages along the Y-Axis. The thermometers are showing spending based on a budgeted number. Currently, the project is over-budget so I have adjusted the thermometer scale to go far beyond 100%.

I would like to have the percentages past 100% show in red along the lefthand side.

View 2 Replies View Related

Removing Percentage Sign On Excel Chart Axis?

May 21, 2014

I realize all the numeric data was originally not in percentage format (a simple division without being multiplied by 100). So when I set the vertical axis to percantage format, it does display it as a percentage but with the "%" sign. Is there any way I could get rid of the sign? It's not necessary as the axis has already been titled accordingly. I'd hate to redo all calculations, multiply by 100 and then create new charts only to get rid of the sign...

View 1 Replies View Related

Add Percentage To Numbers

Nov 25, 2008

I was wondering what the formulas was for adding 20 percent to a price of lets say 10.00. What would I use for this?

View 2 Replies View Related

Bubble Chart Function - Click To Open Percentage By Subject Line

May 23, 2014

I am new to excel and to the bubble chart function and need creating one for a presentation.

I was asked to do a bubble chart to show the open and click to open percentage by subject line

E.g.
Subject line: Win 20% open, 23 % Click to Open, Getaway 20$ Open, 21% CTO etc., to include an industry average for open and CTO in the chart.

X axis: click to open and Y axis: open

I tried the following in the picture and it doesn't look right.

Capture.JPG

View 1 Replies View Related

Excel 2007 :: Create Bar Chart That Changes Color Based On Percentage Range

Aug 7, 2012

I am trying to create a bar chart that changes color based on a percentage range. Any advice on how to do this? I am using Excel 2007, Windows XP, Sharepoint 2010.

View 1 Replies View Related

Countif Between 2 Numbers That Are Percentage

Jun 18, 2012

I'm trying to figure out 2 seperate formulas - see sample data below:

1) how many are 0% (Answer: 3)

2) how many are greater than 0 but less than or equal to 24. (Andwer: 2)

I can't come up with the 2 calcs.

There is a formula in cells below (Example: =$BA150/$BA$3). Will my calculations just not work when there is already a formula in that cell?

14.3%

71.4%

42.9%

71.4%

0.0%

[code]...

View 3 Replies View Related

Lookup / Match And Index To Return Percentage To Table To Draw A Radar Chart?

Jun 25, 2014

I'm struggling with match, index and lookup functions. I have a formula in column D that calculates the percentage of answers against the total score for that category. The way it calculates enables me to delete rows if they are not needed and still provide a total count and a percentage score.

Now the percentage is returned from a dynamic data set, I want to plot the percentages on a spider/radar chart. Instead of manually creating the chart or using a pivot, I wanted to lookup the percentages (column D) against the category (Column A) in question and plot so the chart updates as the user changes the answers.

View 3 Replies View Related

Convert Numbers With Decimals To Percentage

Nov 11, 2008

I have a spread sheet with over 200 numbers like 3.3, 4.5, 6.6 and so on. Is there and easy way to convert them to Percentages?

View 2 Replies View Related

Percentage Change Between Range Of Numbers?

Feb 27, 2013

Pretend their are two Tabs in excel.

Tab 1:

"A1" contains a random number: "20"

Tab 2:

Column "A" has tonnes of random numbers:

6000 - Starting Balance (changeable)
5890
5800
5950
6080
6100
6180
6250
6300
an so on... (1,000 rows)

Based upon the number "20" that I placed in A1 on Tab 1, I want a formula that looks at the first 20 rows in column A within Tab 1, and then calculate the percentage change between the extreme "peak to trough" of the highest number to the lowest number within the 20 rows...

Below should make it really simple:

6000 - Starting Balance (freely changeable)
5890 -1.83%
5800 -3.33% - This was the lowest percentage change from the starting balance of 6,000
5950 -0.83%
6080 +1.33%
6100 +1.67%
6180 +3.00%
6250 +4.17%
6300 +5.00%

View 3 Replies View Related

Calculate Percentage Of Positive Numbers Only

Jun 28, 2007

I am trying to find a formula to calculate the percentage of the positive numbers in a column. For example, if I have a column that has positive(green) numbers and negative(red) numbers in the cells to show over daily goal or under daily goal, and I want to at know what percentage of all the numbers are the positive ones.

View 3 Replies View Related

Calculate Numbers Required For X Percentage

Aug 14, 2007

what I'm trying to do.

Background:
I play a game that requires 5 members to play, however you can have more then 5 members on the team. In order for a player to receive points for playing they must have played at least 30% of the total games played. The problem for me is when trying to figure out how many games someone needs to play to get to 30%, the total goes up as they play those games.

What I would like to accomplish:
I'm looking for help on a formula that would figure out how many games a player would need to play to get to 30%. I have a column that is total games played, %of games played by player, games played by player, and games needed to play to get to 30%. Basically the user would enter the # of games played by each player, and the total games played overall for the team for that week, the spreadsheet would then show the # of games each player that isn't above 30% would need to play.

I tried to make the question as clear as possible, if anyone needs clarification,

Originally Posted by shg
Welcome to Oz, Basca

spreadsheet with a representative sample of your data?

Games Played
Player 1 20
Player 2 7
Player 3 13
Player 4 20
Player 5 13
Player 6 13
Player 7 7
Player 8 7

Total Games Played20

View 9 Replies View Related

Percentage Of Number Greater Than Other Numbers

Sep 7, 2007

"in Excel" - my formula for cell C11 is: "What percentage of the time (occurrences) was the value in cell B11 greater than the values in A1 thru A10?"

As in...:

100
99
98
97
96
95
94
93
92
91
90...95.....40%
89...16.......0%
88...123...100%
87...90......20%

So no data in first 10 rows of Col B. (Or Col C, of course.) Then for the value that appears in B11, how many times (out of 10, in this example for sake of ease) was that value greater than the entries in the first ten entries in Col A:

95 (cell B11) was greater than A10, A9, A8 and A7 (91, 92, 93 and 94). So 4 times out of 10, B11 was greater; 40% is the answer the formula would yield.

16 was never greater than any entries in A2 thru A11, so 0%.

And 123 was greater than all the entries in A3 thru A12, so 100%. Etc, copied down the sheet...

View 5 Replies View Related

Percentage Of Numbers In Range Greater Than Another

Jan 6, 2008

I have two columns A and B. In each column are a list of numbers. I want to count the number of times the numbers in column A are greater than the numbers in column B and display it in the form of a percentage. An even easier way for me to do what I need is as follows...I have a third column (column C) that subtracts A from B...if it is a negative number, the cells in column C are autoformated to color the cell red. If it's a positive number, the cell is colored green. Is there a way I can count the number of cells that are red and divide them by the number of cells that are green to get a percentage?

View 2 Replies View Related

Find Lowest Percentage In A Series Of Numbers

May 27, 2014

I have a series of numbers in cells B2 to G2. The maximum value of each of these columns is found in B5 to G5. Is there a formula that will calculate the percentage of each of the values in row 2 (B2 to G2) and tell me which is the lowest number based on the percentage? Example...

Row 2: 12, 100, 43, 1444, 141, 332
Row 5: 25, 140, 55, 3000, 244, 440

Which number in row 2, is the lowest percentage of the total possible points found in row 5?

B2 is 45% (12 divided by 25), C2 is 71%, D2 is 78%, E2 is 48%, F2 is 58%, G2 is 75%.

I want a formula to tell me in a new cell that "12" (in B2) is the lowest percentage in that series.

View 4 Replies View Related

Find Percentage Increase / Decrease Between 2 Numbers

Mar 4, 2014

I have totals in d18 and e18 and need to find the percentage increase or decrease between the 2. E18 is last year's value and D18 is this year's value. Which formula will give me what I am looking for:

(D18-E18)/D18 or (D18-E18)/E18

View 2 Replies View Related

Show Numbers Based On Percentage In Cell

Sep 15, 2007

I have a rather large report full of data, 10+ columns contain a RANKING column, and these ranks, 1-10, are assigned by a % bracket:

1-20% = 1
21-40% = 2
41-60% = 3
61-80% = 4
81-100% = 5
101-120% = 6
121-140% = 7
141-160% = 8
161-180% = 9
181-200% = 10

There are several hundred rows in each column that all need individual ranks. My first thought is to program a if then else statement for 1 to 10 with a % limit range, but this isnt feasable as i would have to program a separate if statement for each of the many hundred rows, or do one heck of a fancy loop that i just cant contemplate (as the rows are split and sepperated... no solid uniform place for the data to be plugged.) What is the best way to go about this? I'm at a total loss of ideas with my knowledge of excel.

View 2 Replies View Related

Automatically Increase Numbers At Interval By Percentage

Apr 21, 2008

how to make a number automatically increase by a percentage at a certain interval.

For example, 1-12 need to be 3% of 100, so, 3. Then, from 13-24 need to be 3.5% of 100, and so on. Does anyone know how to do this?

View 6 Replies View Related

Missing Numbers From Chart?

Nov 24, 2013

I have a 5x5 table which is filled by random numbers ranging from 1 to 99. I need to make a function that shows me all the numbers that are missing between 1-99.

View 1 Replies View Related

Chart X-Axis To Display Specific Numbers

Jan 10, 2008

I am trying to format my x-axis to list only the labels that have corresponding data points, but at the same time maintain appropriate number spacing. For example, My x-axis range is 0-90; however, I only want tick marks at 0, 5, 13, 40, 85.

View 4 Replies View Related

Format Chart Labels For Numbers With Commas

Mar 19, 2008

I know from searching through the internet you can change the intervals by modifying the minimumScale, maximumScale and MajorUnit fields of TickLabels. What I want to do is change the period of the axis label to a comma. For example,

if it shows

10.00
5.00
0.00

I want it to show

10,00
5,00
0,00

View 7 Replies View Related

Chart Axis Has Numbers But Data Range Is Names?

Jan 21, 2014

I have created a chart but for some reason rather than the names appearing there are numbers. I did the chart successfully and then removed the data so that I could input another team's results and this happened.

View 3 Replies View Related

Conditional Formatting Based On Percentage And Insert Cell Based On Percentage

Apr 3, 2013

I have a workbook that I've built for a project. I've attached a sample workbook. What I'm trying to do, for the entire sheet or workbook if possible, is turn any Cell with a percentage of 30% to 49% yellow and any cell with a percentage of 50% or more Red. I would also like to move the ID's of the variable cells, for example Id number 9922, to the cells beside the description of the rows, Affected would be an example, if the information contained in the same row as the ID meets with a set of variables.

For example I only want the ID's moved if they correspond with IDsub 1-25. One more thing, the people who will be using this spreadsheet will be copying data from a website when it is imported it does not insert the values as numbers. I would like to format the cells, in example workbook they would be any of the cells labeled ID IDsub Variable or Number, so that anything put in that cell will automatically be converted to a number.

I should also probably add that the formatting will be done on approximately 80 rows a sheet with 47 sheets.

View 2 Replies View Related

Calculate Percentage Of A Percentage?

Apr 26, 2013

calculating the percentage of a percentage and writing the formula for excel.

There are 295 people in a room, of the 295, 75 or 25% are mothers. (I know how to calculate 25% - 75/295 = 25.42) of the 75 mothers 35 have 3 children, 32 have 2 children and 10 have 1 child.

35 is what percent of 25%
32 is what percent of 25%
10 is what percent of 25%

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved