Preparing a stacked chart

Copper Contributor

Hi Experts;

 

Please help me in preparing the stacked chart as in the image below

Excel SampleExcel Sample

Regards

Sreejith 

 

6 Replies

@EuroSree Try the attached.

Hello @EuroSree,

 

First suggestion would be to transform the data to look as follows:

PReagan_0-1581948700981.png

Once you transform your data, review the following Clustered Stacked Bar Chart video on YouTube. Review also the attached workbook. Please let me know if you have any further questions.

 

Thank you so much
I had seen the videos but the arrangement of the data was the problem.
Thank you so much for working out the option for me

@EuroSree 

 

My pleasure!

Hello @PReagan 

 

i want something similar. I have the following example where from Company 1 and 2 i have one price given for a product where from company 3 i have a range of prices for each product. How can i present it in one bar chart for presentation? (a mix of normal price and a bar showing a range in the same chart=

 

 Company 1Company 2Company 3
Product 1100000150000110000-130000
Product 2500000250000230000-260000
product 315000010000090000-120000