creating excel chart from 2 different columns

[biot]

Hi
I'm tring to create chart from Column B (to be X axis), and column D (Y axis).
when I set it as range: .range("B":"D") - it'll take also column C.
How can I set range for chart to be column B and D only??
Thanks.

 

[Jon Peltier]

You need to use something like union(.range("B"), .range("D")).