Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
text on speadsheet, converted to % value in chart
I have a 10 step process. How do I give text "X" a 10% value on the
spreadsheet so it will display as 10% for each completed step in a chart? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
text on speadsheet, converted to % value in chart
In a seperate cell, do something like
=COUNTA(A2:A10,"X")*10% and then base your chart off of this new cell. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RenKemp" wrote: I have a 10 step process. How do I give text "X" a 10% value on the spreadsheet so it will display as 10% for each completed step in a chart? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
text on speadsheet, converted to % value in chart
Luke, we are mixing metaphores
should be =COUNTIF(A2:A10,"X")*10% -- If this helps, please click the Yes button. Cheers, Shane Devenshire "RenKemp" wrote: I have a 10 step process. How do I give text "X" a 10% value on the spreadsheet so it will display as 10% for each completed step in a chart? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
text on speadsheet, converted to % value in chart
Thanks for the reply, but this isn't working with the way I am trying to set
it up. Maybe I'm using the formula wrong or I need to include more cells. Maybe a little more info would help. Columns H - Q are the 10 steps to creating a class. Rows 2 - 40 list all of the classes. If I put an "X" in the H2 cell, I want the chart to display that 10% of the process is done. If I put 10% in each cell, it works perfectly. But I need to put an "X" in the cell instead and have 10% as it's value. Thanks, Ren "Shane Devenshire" wrote: Luke, we are mixing metaphores should be =COUNTIF(A2:A10,"X")*10% -- If this helps, please click the Yes button. Cheers, Shane Devenshire "RenKemp" wrote: I have a 10 step process. How do I give text "X" a 10% value on the spreadsheet so it will display as 10% for each completed step in a chart? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
text on speadsheet, converted to % value in chart
Thanks for the reply, but I think I'm using the formula incorrectly. Do I
add the 10 cells in a row, or do I include all 400 cells in the formula. If I enter 10% in each cell, it workds perfectly on the chart. I just need to put an "X" in each cell and have the chart continue to read it as 10%. How do I make "X" =10% for each of the cells? "Shane Devenshire" wrote: Luke, we are mixing metaphores should be =COUNTIF(A2:A10,"X")*10% -- If this helps, please click the Yes button. Cheers, Shane Devenshire "RenKemp" wrote: I have a 10 step process. How do I give text "X" a 10% value on the spreadsheet so it will display as 10% for each completed step in a chart? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers converted to Text | Excel Discussion (Misc queries) | |||
Date converted to Text Number | Excel Discussion (Misc queries) | |||
Text Converted to a Picture | Excel Discussion (Misc queries) | |||
Text is being converted to Date | Excel Worksheet Functions | |||
Database text converted to numeric | Excel Discussion (Misc queries) |