Forum Discussion
Preparing a stacked chart
Hi Experts; Please help me in preparing the stacked chart as in the image below Regards Sreejith
Hello EuroSree,
First suggestion would be to transform the data to look as follows:
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.
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
Thank you so much for working out the option for me
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 1 Company 2 Company 3 Product 1 100000 150000 110000-130000 Product 2 500000 250000 230000-260000 product 3 150000 100000 90000-120000
