Thread: text on speadsheet, converted to % value in chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default 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?
Reply With QuoteReply With Quote