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.

Column A Cells 1 thru 10 can be marked with your X In Cell A11 format the cell as percentage ( % ) put the formula: =COUNTIF(A1:A10,"x")/10 MIKE http://www.skeptic.com/

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")/10 I know that you can assign a Name to a formula, such as PercentComplete refers to: =COUNTIF(Sheet1!$A$1:$J$1,"X")/10 but 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...

Got it! Insert...Name...Define Names in workbook: PercentComplete Refers to: =COUNTIF(Sheet1!$A$1:$J$1,"X")/10 Start the Chart Wizard Select your chart type, click Next Click the Series tab Click the Add button In the Values field enter: =WorkbookName.xls!PercentComplete Format the rest of the chart options as you like Click Finish Note: You must include the Workbook Name in the Values field or you will get an error.