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.
Create stacked column chart
-
-
-
Re: Combining Pillars in the graph
Instead of a Clustered Column type chart, look up the Stacked Column.
-
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.
-
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
-
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 -
-
Re: Create stacked column chart
Here is how the final result will look like
-
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? -
Re: Create stacked column chart
I do not know whether it is possible or not
-
Re: Create stacked column chart
See file attached if it makes sense
-
Re: Create stacked column chart
try this.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!