Sorry for the delayed reply, only just got back in to work.
Thank you for you help, I came to a similar conclusion over the weekend and have gone for creating a helper string in VBA. As the data is exported into excel from an external program and we have 100's of sets of test data. I went for...
I'm not sure how I would be able to use that method. My data measures an error rate depending on different power levels, so I require a line graph. This measurement is then repeated at three different temperatures. This test is then repeated for multiple different modules.
Ideally I would like...
Hi,
I am struggling to work out how to use two cells to create the name field for a series on a chart. I have three sets of results which come under one test, and there are multiple tests (see table below). I thought it would be possible just to use "&" to combine the two cells together when...