Using VBA To Update Chart Data - 2 Ranges

I am making a macro to update the data on a bunch of charts. This is what I got from the macro recorder when I selected the data manually.

Code:
Sub testthree()
ActiveWorkbook.Charts("Julian's Words").Select
ActiveChart.SetSourceData Source:=Sheets("Super Sight Chart Data").Range( _
"C1:H1,C5:H5"), PlotBy:=xlRows
End Sub

I have created the part of the macro that will go to the data table and define the two ranges I need to use.

Code:
Sub Adjust_Graphs()
Dim lastdate As String
Dim daterange As Range

[Code] .....

However, this code is selecting the entire range C1:H5. How can I get the code to take JUST the two lines I need?

Exmaple: The X axis needs to be C1:H1, and the Y axis needs to be C5:H5.

I also tried this, without success:

Code:

Dim combrange As Range
Set combrange = Union(daterange, wordrange)
ActiveWorkbook.Charts("Julian's Words").SetSourceData Source:=Sheets("Super Sight Chart Data").Range( _
combrange), PlotBy:=xlRows