Question Locked

Text input, percentage output on an Excel chart

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a 10 step documentation process (10 column headings). I want to enter an "X" on the spreadsheet to show that a step has been completed. The issue is this...I want each "X" from the spreadsheet to be interpreted on the chart as 10% of each part of the process. I can get it to work if I enter 10% in each cell, but my client wants an "X" in the cells of the spreadsheet. Any suggestions?

2 replies

by thumbsup2

You can put a formula in a cell off to the right of your X's, format the cell for percentage, hide the entire column and still be able to use it to chart.

=COUNTA(A2:J2)*0.1

This counts the non-empty cells and multiplies the result by 0.1 which turns the count into something that will format properly when that particular cell is formatted as a percentage. So, if you had 4 cells with an X in them, the result would be 40%. If you don't want the result of the count turned into a decimal number or don't want to format the cell as a percentage, you can leave off the *0.1 part of the formula.

To hide a column, right click the column letter and choose Hide from the resulting menu.

This discussion is closed to new replies.