On the sheet data summary in row 12 I have created a stacked bar chart. Is it possible to copy this stacked bar chart for the rest of the rows in the Data Summary sheet? When I manually copy it I have to change the data selection and then changes the colours again manually. There must be an easier way!
Thank you!