I am trying to get the chart on sheet 'B1Graph' to display the data for each particular feature on the sheet 'Data' depending on what I pick from the drop down box in 'B1Graph' Cell L2
I am having trouble getting the graph to automatically update and I can't understand where I'm going wrong in my name manager formulas.
Ideally, the row 'Dimension' would be a fixed line (i.e. for Hole A Dia = 0.451) that line would go across as a constant for all weeks.
Please could somebody see attached and help me understand where I went wrong?