ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Please help with complex graph! (https://www.excelbanter.com/charts-charting-excel/261053-please-help-complex-graph.html)

Matt S

Please help with complex graph!
 
I am trying to make a stacked bar chart. I made a picture of what I'm trying
to do, but I do not see how to attach a file to this post, so I will do my
best to describe it.

On the x-axis are three species I measure. The y-axis is the total grams of
the three species exhausted. I may have 3-4 samples that have been tested
for the total grams, which I would like side-by-side for each of the three
species. On top of that, the total grams for each sample are split into
three sections in the test (Bag 1, 2, and 3) that I would like stacked. If I
can figure out a way to attach a file, a picture might be more helpful.

Any help is appreciated!!
Matt

Andy Pope

Please help with complex graph!
 
Hi,

Sounds like a cluster stacked column chart
http://peltiertech.com/WordPress/clu...column-charts/

Cheers
Andy

On 08/04/2010 22:09, Matt S wrote:
I am trying to make a stacked bar chart. I made a picture of what I'm trying
to do, but I do not see how to attach a file to this post, so I will do my
best to describe it.

On the x-axis are three species I measure. The y-axis is the total grams of
the three species exhausted. I may have 3-4 samples that have been tested
for the total grams, which I would like side-by-side for each of the three
species. On top of that, the total grams for each sample are split into
three sections in the test (Bag 1, 2, and 3) that I would like stacked. If I
can figure out a way to attach a file, a picture might be more helpful.

Any help is appreciated!!
Matt


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com