you just saved my life!! I was looking for this as a crazy bear lol.. Thank you so much

Clever guide, thanks for putting it together, I was trying to do this with a chart embedded within a powerpoint deck, the data is using embedded data, rather than linked externally to an excel doc. I'm currently looking for a way of pasting the "labelspots" data series into the chart, but it pastes a table of the numerical data over the top of the chart, rather than adding a new set of columns into the graph.

Thanks heaps! This was exactly what I needed! I knew it was possible but overlooked the "value from cells" part!

Brilliant! Well Done

how amazing