Using a template worksheet that contains a chart

  • Hi all, I have a spreadsheet that creates a new worksheet every time a form entry is made. The problem that I have at the moment is that the worksheet being generated from the template is not creating a functioning chart. When generated, the chart has no data but when the first entry is made, I want the chart to show it based on a pre-selected column.

    Current behaviour is that the chart SEEMS to have the right references BUT I have to go in and edit the correct Category axis reference (to the same thing!) and then make an edit to any cell in the worksheet in order for the chart to function. VBA is below and happy to share the spreadsheet if it is any help!