Chart from cell with two data values

[trentnielson]

I want to make a chart (specifically a stacked column) from cells that have two data values (there are two functions separated with the &" "&) the first function is a running total for the month and the second function in the cell is the weekly total. I would like to create a stacked column that uses the weekly vales but still displays the monthly running total with each of the weekly values.

Can this be done? Does this make sense? Please help!!

 

[PCL]

I would suggest to spilt into 2 values and prepare the chart from this 2 values. Perhaps can you send an example of your data and expected result.