create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10)

[Prof Jack]

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.

 

[Tushar Mehta]

A concatenated cell contains a string. XL can only plot that on a
Category axis (x-axis for charts such as Line, Column, Area). It
cannot use a string for a y-value.

What you may want to do is plot the decimal equivalent and then use the
ratio column as a label for the plotted series.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions