It's not the cleanest and i'm sure my formatting isn't right on the other chart page, but in the end i can hid column e and this works.

Thanks for your help. I appreciate it.