Create stacked column chart

ha.haider · Jul 20th 2011

Dears,

Hope that you all are good.

Attached fine contain a graph for different types of product with a number of quantity sold for each product along with their amounts.

My question is that is there a way to show only 1 pillar for each product which indicate at the main axis the quantity sold and the secondary axis the amount of sold quantities?

I would like to have one pillar per product instead of two.

ShosMeister · Jul 20th 2011

Re: Combining Pillars in the graph

Instead of a Clustered Column type chart, look up the Stacked Column.

Jon Peltier · Jul 21st 2011

Re: Combining Pillars in the graph

Make an XY chart, X = Number and Y = Amount.

To identify the points, you can use a utility like Rob Bovey's Chart Labeler.

ha.haider · Jul 24th 2011

Re: Create stacked column chart

Dears,,

Would you kindly help in this subject?

Kindly have a look at the attached sheet. It is totally unprofessional. I did not like it. I want to have one pillar for each product. The pillar should read on the left axis the quantities and on the right axis the amount.

Is that possible?

plz help

**PCI** · Jul 24th 2011

Re: Create stacked column chart

Please can you give an example of the final result you expect.
How the same pilar can be used for 2 differents topics: For one product it can fit but for 2 products how is the result

ha.haider · Jul 24th 2011

Re: Create stacked column chart

Here is how the final result will look like

**PCI** · Jul 24th 2011

Re: Create stacked column chart

Do you think it is possible?
The first Y axis is prepared and then the pillar fit to the scale.
How to make the second Y axis from the pilar?

ha.haider · Jul 24th 2011

Re: Create stacked column chart

I do not know whether it is possible or not

**PCI** · Jul 24th 2011

Re: Create stacked column chart

See file attached if it makes sense

ShosMeister · Jul 26th 2011

Re: Create stacked column chart

try this.

Create stacked column chart

Participate now!

Share