This is probably a very simple answer, but beyond my very limited knowledge of VBA/macros
I recorded the macro below to show this stage in its simplest form. This is what it records if I perform the range selection manually. However I want to replace this manual range selection with a pop up to select the data during part of a larger macro.
Many thanks in advance for any light that you can shed on this.
Sub Under_80_Votes() ' ' Under_80_Votes ' Transfer of data to charts ' ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.PlotArea.Select ActiveChart.FullSeriesCollection(1).Values = "='<80% Votes'!$P$18:$P$23" ActiveChart.FullSeriesCollection(2).Values = "='<80% Votes'!$Q$18:$Q$23" ActiveChart.FullSeriesCollection(2).XValues = "='<80% Votes'!$O$18:$O$23" End Sub