creating clustered stacked column bar charts (1 Viewer)

[prabhus]

Hello All,

Is it possible to create clustered & stacked column bar charts together in a same chart? please hlep!

 

[JHB]

Yes if the attached picture is what you are looking for, (with some small tricks).

 

[prabhus]

Hi JHB, this exactly what i am looking, could you please help me, how to do it?

 

[JHB]

Hi JHB, this exactly what i am looking, could you please help me, how to do it?

Yes, send me some sample data, in a Database or Excel-sheet.
Tell which column should be stacked and which not.

 

[cmoffice]

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

 

[JHB]

Send me some sample data, in a Database or Excel-sheet.
Tell which column should be stacked and which not.
Then you can play with it or look at it afterwards, it is easier for me as making a long description.

 

[cmoffice]

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,

 

[JHB]

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,

What you show me in the Excel sheet are 2 stacked bar, not a cluster & stack column bar.

 

[cmoffice]

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 : peltiertech.com/WordPress/clustered-stacked-column-bar-charts/

Anyway, that is exactly what I am trying to do now with Access 2010.
So, if you can help me in achieving this, I would appreciate.

Thanks again for your time and help,

 

[JHB]

Honest, I've never thought so deep about that, I've only looked at the definition what MS-Access shows, for the column type.
The only way at the moment I can see a solution, is by placing two graph objects on top of each other, one transparent and one with a offset relative to the other, and the of cause with the same scale.

 

[cmoffice]

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 point : your image is combining a column chart with a stacked chart while my request is to have a combination of two stacked charts which is not feasible apparently. The other solution with the offset you described is indeed a solution but rather tricky to implement. I''ll try that one if this is the only one available.

 

[istudychimps]

Hi JHB, I hope you get an alert that I'm posting this since it's quite a while since the original post. Anyway - the combined clustered / stacked graph you posted in your picture is exactly what I need to do with my data. Can you please advise on how to do that? Basically, I have research data that I need to present as # interviews (Y axis) by month (X axis), case vs. control (clustered) and cases need to be stacked by hospital site (KCC vs. McLaren). Hope that makes sense? I'm attaching data - if you need more guidance please let me know. Please help - my email is pandolfs at karmanos dot org (it won't let me include my email address using normal symbols...)
THANKS!

 

[JHB]

I got your data and read you question, but are you able to give me a printscreen of how you want it, (you can draw some boxes)?

 

[istudychimps]

Thank you SO much! here is a pdf of the exact way I want the graph to look - I was able to do it in Excel, but it takes some finagling, and I would prefer to do it programmatically in Access! Again, thanks for your help!

 

[JHB]

I've made a solution in the attached database.
You need to open the report in "Print Preview"!
Read the the comments in code on the OnLoad event.

 

[istudychimps]

This is very helpful and exactly what I'm looking to do, but can you please explain how to adjust the query (or set up the report) so that I can re-create it for future use (I need to run the report monthly based on updated data). Thanks again for your time and help!

 

[JHB]

.. but can you please explain how to adjust the query (or set up the report) so that I can re-create it for future use (I need to run the report monthly based on updated data). Thanks again for your time and help!

There should be no need for adjusting it, it is update automatic.

 

[Misiek]

@JHB,

1. Is it possible to have query as source?
2. Do I have to create a table to drop it all into?
3. Can I have more than 1 chart on the same report (based on the same query)

Thanks


Update:
No longer relevant. Fixed it with pivot query.