VBA to create graphs with split data.

[And180y]

I saw this thread https://www.excelforum.com/excel-pro...te-graphs.html
and thought it would be cool to have that under a table I was working on.

However whilst I can manipulate the data into the same format as the solution Crooza gave in the thread above to make it work it's a bit cumbersome and spacious.
Is there a way to click on a name (or a button as per Crooza's solution) and utilise the data Eg. ABC would display the data from E5:M5 as per the attached sheet?
Any suggestions for emphasising the 99.50% gridline?


Thanks in advance for any help

[And180y]

Anyone able to help, please?

[Andy Pope]

You can use formula, in a fixture range, to index the data table.

Horizontal line can be provided by positioning the horizontal axis at .995

You will need to use a non 3d chart.
And in order to show the data, with such small variation, you should use a different chart type to column.
Use the data validation in the yellow cell (D1) to change name.