Change the data range for an existing chart

Hi,

I was given responsibility for some existing code that takes data from a table (range T55:Y55) and generates
a line chart....and this works fine. The chart (named: "TCEQSMBFPY") was set up with the data range entered
manually via RMC on the chart --> Select Data --> Edit chart data series.... This was set up for a fixed range
table for 6 months of data and I want to - via VBA - programmatically change the month range between 6 (T55:Y55)
and 12 (T55:AE55) months.

How do I specify that, for an existing chart named "TCEQSMBFPY", change the current data range: T55:Y55 for 6 months of data to
T55:AE55 for 12 months of data?

Thanks for any help provided.

Thanks Sweep! This does exactly what is required however, I'll need to also change my (Y) axes
from 12months to 6months...Currently, the horizontal axis was manually set to: Axis label range: =
'TCEQ Segments'!$T$54:$AE$54 (for 12months)
The 6month range would be: T54:Y54.
How do I change the horizontal axis range in VBA?

Thanks again.