I assumme there is an offical way of doing it, but i only know this way and while it works there are some limitations.
so a further cheat...
Put the data on sheet2, base your graph with a target on sheet 2 then just link the bits you want to show on sheet1
see attached
let me know if its what you were after
|