hi everybody I'm importing data from excel files. I need to generate a bar chart with a lot of series. My X axys have the name of my consultants (almost 300 names) and each bar series is the project where each one is working on. This works fine when i have 10 guys and just 3 projects, but when i have 300 guys and more than 40 projects that's where the problem begins. I was trying to make DynamicHeight works but i just can't make it work, dont know why. And even if i expands my chart area manually, each serie's space keeps same space to everybody to generate all bars, even if the all bars dosen's appear, this way the bars looks thin like a guitar string...that happens cuz the reporting services calculates same space series to everybody based in all series. Hope i was clear... I already read this famous page: http://blogs.msdn.com/b/robertbruckner/archive/2008/10/27/charts-with-dynamic-size-based-on-categories-or-data.aspx There is someway to make it shows only the project bars where the guy works and make the chart area expands automatically to keeps everyone? this is the expression that i'm using in DynamicHeight Properties Chart =(CountDistinct(Fields!analista.Value) * CountDistinct(Fields!projeto.Value)) * 0.45 & "in" Thanks a lot guysPra treinar qualquer bola serve.

Hi, From your description, I am still confused about how does the DynamicHeight not work in the bar chart. If possible, please post screenshots to show the scenario. Based on my testing, if we specify the field analista as category group, specify projeto as series group and specify another field, for example amount as data value, the DynamicHeight expression =(CountDistinct(Fields!analista.Value) * CountDistinct(Fields!projeto.Value)) * 0.45 & "in" works fine. So, if I have something misunderstood, please also point out. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.