VBA within Excel_revised

Hello,

I have graphs that are updated every quarter using VB in excel.  These are column graphs with labels which are locations (only 8) like WA, OR, TX underneath each  column.

I would like to keep the locations and include a data table underneath the columns using vba in excel but I am new to vba. How would I do this using vba    

Thanks very much in advance..  

Here is the code..the "has data table" does not work but the rest of the code does.

'chart configuation

activesheet.chartobjects("chart 13").chart.chartTitle._

Chartacters.Text = "TX B use 6 months."

ActiveSheet.ChartObjects("Chart 13").Chart.SetSourceData_

Source:=Sheets(CBHChartSourceData").Range("B2:F15")

ActiveSheet.ChartObjects("Chart20").Chart.HasDataTable_

Source:=Sheets(CBHChartSourceData").Range("C129:F138")

ActiveSheet.ChartObjects("Chart 13").Visible = True

ActiveSheet.ChartObjects("Chart 20").Visible = True

End Sub