Charting with concatenated numbers and text

  • Thread starter Thread starter Alan Dresch
  • Start date Start date
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.
 
Change the text result to a number in your formula. For example:

=RIGHT(A2,2)+0
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create Drop down list in Chart? 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Can't drag new data to chart in 2007. 1
setting scale on chart automatically 1
Chart Help 1
Data Validation Problems with Charts 1
Chart Title change with Drop Down Selection 2
Excel 2007: continuously update scatter chart from scroll bars 1

Back
Top