For this sort of thing I have a Sub-Series (series type) column, then in (main) Series I have World/Realm name and use Series# as overall read/chronological order, then in Sub-series have the actual Series that they belong to and Sub-series# is their order in that
E.G, (Although these are same author, the principle still applies)
Code:
Daggerspell Deverry 1 Deverry 1
Darkspell Deverry 2 Deverry 2
Dawnspell Deverry 3 Deverry 3
Dragonspell Deverry 4 Deverry 4
A Time Of Exile Deverry 5 Westlands 1
A Time Of Omens Deverry 6 Westlands 2
A Time Of War Deverry 7 Westlands 3
A Time Of Justice Deverry 8 Westlands 4
The Red Wyvern Deverry 9 Dragon Mage 1
The Black Raven Deverry 10 Dragon Mage 2
The Fire Dragon Deverry 11 Dragon Mage 3
The Gold Falcon Deverry 12 Dragon Mage 4
The Spirit Stone Deverry 13 Dragon Mage 5
The Shadow Isle Deverry 14 Dragon Mage 6
The Silver Mage Deverry 15 Dragon Mage 7
If you have short stories or whatever you can also add them in as #.##, e.g. 3.2, or 3.5 etc.