Named Range in a chart.

Hi There,

This might be an easy question, but is it possible to have named range in quotes?

For example the code below selects a range in a chart based on a users selection:

Please Login or Register  to view this content.

If however, I had a named range called 'Category' which referred to $B$10:$B$19, and a named range called 'Sales' which referred to $AE$10:$AN$19, is it possible to replicate the above code, so essentially it would look something like:

Please Login or Register  to view this content.

The problem with the above is that it does not just select $B$10:$B$19 & $AE$10:$AN$19 - it also selects every column in between. So column C, D, E etc... are also selected.

The only difference between the codes above are the quotation marks. Is it possible to use quotation marks with named ranges, or is there another way completely?

Thanks for any help in advance.

Ashley

Try this

Please Login or Register  to view this content.

post example file so we can see the named ranges and your chart code

Hi Andy,

I have attached an example of the chart & code that I'm currently using, which will hopefully make things clearer.

If you have any questions fire away.

Thanks for the help, I really appreciate it!

Ashley

Change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.