Recent content by cmoffice

In my code, I am manipulating (with the valuepoint variable) the datalabel itself (which is formatted in k€). So, this is a string that I have to split (with the k) and than convert with Cdbl to retrieve the real value attached to the point. Not really proper. I would like to work directly...

Thanks, it works now with the event format. How can I change the code so that it works with the real datasheet values instead of the formatted datalabels ? Thank you,

Hello JHB, Not yet. I have experienced some VBA code but that does'nt work. My problems : 1/ My graphs is now completely blank. Not sure that I must trigger my procedure in the Report Load 2/ The code is working with the datalabels value. But I would like to work directly with the datasheet...

Hello JHB, But the JPG file StackedClu.jpg you have attached on 02-23-2013 looks like a clustered stacked column chart (so combining both sub-types). This picture is what I am trying to achieve. Could you post the accdb file you used to generate this chart ? Euh ...wait... I think I got the...

Hmmh ... May be this is not the correct definition. I thought "clustered" mean two adajacent column bars (stacked or not) bound to the same X-Axis value. I just picked up the "definition" and the sample from this site dedicated to XL ...

Hello, I would like to remove small value datalabels in a stacked column barchat. If you look at the image attached, the small value datalabels tend to clutter the image. My graph is a MSGraph.Chart.8 inside a Report. I am working with Access 2010. Looks like the only possibility to remove...

Hello, I have attached some sample data and the expected result in the attached xls file. I am working with Access 2010. Thank you very much for you help,

Hello, Can you please explain how to cluster & stack column bar charts together in a same chart ? It seems that this is feasible but the solution not described. Thank you