Assign text value (%), Chart output

July 2, 2009 at 07:53:44
Specs: Windows XP
 I have a 10 step process for creating classes (10 columns). As each step is completed, an "X" is placed in the spreadsheet cell. How do I assign a 10% value to the "X" in the cell in the spreadsheet so that the chart displays the correct percentage complete? Ex. If 5 Xs are entered in the first 5 columns, the chart would display 50% (of 100%) is complete.FYI...I was able to get this to work without a formula by entering 10% in each cell in the correct column, but I was asked to assign a value to text ( an "X") so the users wouldn't have to enter "10%" in each cell. They would only have to enter an "X" in the cell.

See More: Assign text value (%), Chart output

#1
July 2, 2009 at 08:33:22
 Column A Cells 1 thru 10 can be marked with your XIn Cell A11 format the cell as percentage ( % ) put the formula:=COUNTIF(A1:A10,"x")/10MIKEhttp://www.skeptic.com/

Report •

#2
July 2, 2009 at 08:33:46
 Let's say your X's are going in A1:J1. Use this formula in a cell someplace and then graph that cell:=COUNTIF(A1:J1,"X")/10I know that you can assign a Name to a formula, such as PercentComplete refers to:=COUNTIF(Sheet1!\$A\$1:\$J\$1,"X")/10but I haven't been able to use that Defined Name as the data source for the chart. If that can be done, then you wouldn't need to put that formula in a cell...you could graph it directly from the Defined Name.Let me ask around...

Report •

#3
July 2, 2009 at 10:26:53
 Got it!Insert...Name...DefineNames in workbook: PercentCompleteRefers to: =COUNTIF(Sheet1!\$A\$1:\$J\$1,"X")/10Start the Chart WizardSelect your chart type, click NextClick the Series tabClick the Add buttonIn the Values field enter:=WorkbookName.xls!PercentCompleteFormat the rest of the chart options as you likeClick FinishNote: You must include the Workbook Name in the Values field or you will get an error.

Report •

Related Solutions