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

Report •

July 2, 2009 at 08:33:22
Column A Cells 1 thru 10 can be marked with your X

In Cell A11 format the cell as percentage ( % )
put the formula:



Report •

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:


I know that you can assign a Name to a formula, such as

PercentComplete refers to:


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 could graph it directly from the Defined Name.

Let me ask around...

Report •

July 2, 2009 at 10:26:53
Got it!


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:


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.

Report •

Related Solutions

Ask Question