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.
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.
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
In article <[email protected]>, =?Utf-
8?B?UHJvZiBKYWNr?= <Prof [email protected]> says...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks