Only show columns in chart which has data

[ossa]

hello!

I have a range for horizontal axis labels b5:b30. But at the moment I am only using 3 of these cells. But the chart does not adapt. So only a small view of my chart is in use, the rest are empty for now. I would like my Chart to adapt to the data, so that f.ex if I only had filled one cell, there would be a big column, taking all the space in the chart. Sorry for bad description of my problem. Thanks for any reply!

Ossa

[Ace_XL]

See if this helps...

http://www.excelforum.com/excel-char...el-2003-a.html

[ossa]

thanks for reply!

seems quite advanced. I thought my question was more simple to answer. Its just about making the chart adapting according to my data, not only the range. Any simple solutions?