View Single Post
  #1   Report Post  
Prof Jack
 
Posts: n/a
Default create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10)

I've written a formula that produces rations (e.g., 1:250) by concatenting
"1:"&(a6*w34). How can I persuade Excel to draw charts of the results? It
wants to interpret them all as "1" Thanks for you help.