I've been using Excel for...um...about half my life. I still have to figure out charts from scratch every time I want them, because it happens so rarely ;)
I think I'd just tend to either rearrange my data so the bits I wanted WERE contiguous - or if that was inconvenient because of other requirements on the data, have a separate worksheet of source data for that chart, which was pulling the relevant data from my master sheet - but that makes my databasey brain cry because of unnecessary repetition of data.
I think you /may/ be able to cheat by just selecting the whole block A1:C6 and then not making any use of the data in 'B'...but it's been such a long time since I've played with charts that I could be going mad ;)
no subject
I've been using Excel for...um...about half my life. I still have to figure out charts from scratch every time I want them, because it happens so rarely ;)
I think I'd just tend to either rearrange my data so the bits I wanted WERE contiguous - or if that was inconvenient because of other requirements on the data, have a separate worksheet of source data for that chart, which was pulling the relevant data from my master sheet - but that makes my databasey brain cry because of unnecessary repetition of data.
I think you /may/ be able to cheat by just selecting the whole block A1:C6 and then not making any use of the data in 'B'...but it's been such a long time since I've played with charts that I could be going mad ;)