Select Chart Content with Drop Down

[lhcalbear15]

I am trying to make a dynamic chart with a drop down/cell selection. I have a table with names vs. months. Each name/month has an associated value. I want to display a bar chart that I select with a drop down. i.e. If I select January, the chart will show january's data. If I select February, february's. Etc.

I tried to set my series values as: =indirect($C$1) where C1 is the entry cell for the month and the value corresponds to a named range. I get an error that says "That function is not valid."

When I try to put just the named range, excel highlights the correct range but then tells me that "the formula you typed contains an error. Try one of the following..."

This seems like it should be relatively simple yet I can't find a discussion on this topic. Any help would be much appreciated.

Thanks

[jeffreybrown]

It would be much easier to give you a sample if you included a workbook with you current layout

[lhcalbear15]

See attached example.

I want the cell C1 to change the data used for the table.

ExampleDocumentforForum.xlsx

[jeffreybrown]

Without having to mess with any special formulas or named ranges, this in my opinion is the easiest method.

Look in O4:O20 where this uses a helper cell