Dynamic Data Range for Bar Chart

Thanks Andy. However, I don't see how this solves my problem.
Maybe you didn't open the attached file?

The thing is, that I want my bar chart to include only the rows which have some data. No empty rows. That is the reason why I don't want to select bigger data range than necessary to my chart. (Or actually I need the range to contain the area untill the last used row, so there might be empty rows between that area)

Maybe someone could even include the solution to my example file?

Best regards,

Juhanen

Hi,

Yes I tried to convert the area to table, but unfortunatelly it doesn't work for me. The chart doesn't update. (I'm using Excel 2007)

Maybe I have to use VBA code insted? Macro recording doesn't work so well with charts, so maybe someone could help me out here please.

Best regards,

Juhanen

The example file you sent back works well. However, I don't want the area to be a list. (There are several users so the dropdown is confusing and messes up too much)

So, I would be thankful if someone could help me out with vba code. So I need the range to contain the area untill the last used row and to update to the chart automatically when ever there is a change.

Thanks Andy,

Works just like I asked to.

One more (the last one) question. If I have several columns, and I want to use data from columns A, B and E (and not from C and D) how do I change the code?

Thanks Andy!