Dynamic Data Range for Bar Chart

**Andy Pope** · 05-06-2009, 10:36 AM

Quickest way.

Select A1 and on the ribbon use
Insert > Table

Your now good to go.

**Juhanen II** · 05-07-2009, 02:28 AM

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

**Andy Pope** · 05-07-2009, 12:04 PM

Yes I did see your file and tested it.

Did you try what I suggested?

For me turning the data into a table linked the chart directly to the data.
Adding new information in row 5 caused the chart to update automatically.

**Juhanen II** · 05-08-2009, 01:37 AM

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