2 replies
by renkemp Accepted solution
by thumbsup2 Accepted solution
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.
Trending Software posts
Sort by Trending