A
Alan Dresch
I am scatter charting from columns of data (text and
numbers) that I concatanate into a long string so that I
can use the validate drop down list feature in Excel,
which only supports one column. I use Mid, Left and Right
functions to then pick the relevant charting data from the
string.
Unfortunately although the numbers look good, Excel
does not treat them the same way that it does with
directly entered numbers - and my charts do not display
accurately.
Any ideas to to fix this problem or suggest a modified
workflow. I am not an advanced user but would like to use
the drop down list approach if possible.
numbers) that I concatanate into a long string so that I
can use the validate drop down list feature in Excel,
which only supports one column. I use Mid, Left and Right
functions to then pick the relevant charting data from the
string.
Unfortunately although the numbers look good, Excel
does not treat them the same way that it does with
directly entered numbers - and my charts do not display
accurately.
Any ideas to to fix this problem or suggest a modified
workflow. I am not an advanced user but would like to use
the drop down list approach if possible.