Creating a Graph Using Dynamic Named Ranges

[JasonMcQueen]

Hi,

This is the first time I've attempted to do this and seem to have gotten a little lost along the way. I've managed to create the two dynamic ranges (month and GRPFAC) but cant figure out how to actually get the chart to use those ranges. Can anyone assist?

test6.xlsm

[Andy Pope]

I gave the named ranges different names.

MONTH_LABEL and GRPFAC_DATA

Also put dummy data in sheet to remove the #REF! errors.

Final used the named range by setting then in Select data dialog for the chart

[JasonMcQueen]

Great, thanks. For some reason it was being really fussy about my range names. As soon as I changed them it would work. Bizarre.