Good afternoon,
I'm attempting to re-use some code that I've used successfully previously to define the ranges to be used by a chart embedded in a worksheet.
Dim Chart_Modal As Chart
Set Chart_Modal = ModalSheet.ChartObjects("HR_Modal").Chart
'Sets the Modal chart based on the Col_HR_CAPI_...