Forum Discussion
How to selectively choose data from multiple values in a single cell for use in charting/graphs?
I am wondering how to selectively choose data that exists within a singular cell in order to plot a chart or graph. For instance, I have, quite literally, thousands of cells that have this layout: "x...
Select the range with data.
Copy it.
Click elsewhere.
Click the lower half of the Paste button.
Select the Transpose option.
The data are now in a column.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Tick the check box for Space, then click Finish.
You now have the 'x' numbers in a separate column.