percentages

Students assignement1 assignement2.. blank clmn total(%) a 12 9 5 b 15 6 4 max pt on *** 20 10...

I would like my bar chart to have two vertical axes. The left one for values and the right one for percentages with horizontal lines connecting the values on the left with the percentages on the right. I managed to draw and label a right axis on my chart (the line with a shape and the...

Hello! This is a math-type question. I am using this guide: http://www.mrexcel.com/tip095.shtml To create a thermometer to show how close we are to completion. Basically I have a total of 42 sessions with 3 complete and I need the thermometer to show what % we are complete in a 100%...

I know there is probably a simple explanation, but I'm missing it somewhere along the way - I am trying to format some cells that contain percentages to show in a parenthesis instead of with the negative symbol: (9.99%) instead of -9.99%. I've even tried custom formatting, but haven't been able...

I am using this formula in my spreadsheet =IFERROR(SUM(AQ5+AN5-AO5)/AP5,0) , but sometimes I get a negative %. What can I do to have a negative % just show 0%? If I need to post a partion of my spreadsheet I will...thanks in advance. Jonathan

Hi, I am recording the downtime of machines and putting into order of most - least downtime for each of the reasons recorded against the machine being monitored. This works fine when sorting the ivot table by the total downtime column. I have been asked if I can add a cumulative percentage...

I need to be able to turn a cell red in B12 if it is within 20%of the value in B3. It seems simple but I cant work out at all how to make it work. Any help would be great. thanks Sean:confused:

Hi there, guys, I've looked through several pages of promising-looking threads and I can't find the answers. I hope some of you guys can help me. QUESTION 1 Basically, I've got a workbook. On one tab I've got all of my data. I want to create a summary table in a DIFFERENT tab, but use the...

Greetings ppls. I need to calculate the difference between a start time/date and a finish time/date, and return the result as a percentage instead of a time value. The end time would be equal to 100% and start time would be equal to 0% The difference is usually always a maximum of 5 days...

Hello, This is only my 2nd post here and I need your help. Can anybody suggest a way to use VBA code or something to Fill boxes and display % of boxes filled as well? I want to use this for people to track progress of projects, and i want them to be able to just push forward and back buttons...

Hi All, I have a document which is trying to work out the total percentage of rejections from a list. Here is a picture of my data And this is the Pivot table at current As you can see it's summing the percentages which is not what I want to achieve. For example, Supplier A - Chocolate...

I have a 10 step process for creating classes. As each step is completed, an "X" is placed in the spreadsheet cell. If 5 steps are complete, I would like to have the chart display that 50% of the process is complete. How do I assign a 10% value to the "X" in the cell in the spreadsheet so...

I have a group of 100 agents who have to evaluate a telephone call and then select the type of call from a drop down list of 200 entries. Because all agents have the same chance of getting the same mix of calls, their selection mix should be relatively similar. I want to be able to show using...