sreekhosh Member Dec 23, 2013 #1 Hi, My data consisting of 4 country's revenue. Which chart is best for showing contribution of each country?. India - 40% China - 31% Nepal - 19% Japan - 10% Regards Sreekhosh
Hi, My data consisting of 4 country's revenue. Which chart is best for showing contribution of each country?. India - 40% China - 31% Nepal - 19% Japan - 10% Regards Sreekhosh
oldchippy Active Member Dec 23, 2013 #2 Something like this? http://chandoo.org/wp/2009/12/02/group-small-slices-in-pie-charts/
sreekhosh Member Dec 23, 2013 #3 Thanks Oldchippy, But Jon Peltier's suggestion is not allowing me to go with Pie. Regards Sreekhosh
oldchippy Active Member Dec 23, 2013 #4 May be one of these others then? http://peltiertech.com/WordPress/trellis-plot-alternative-to-stacked-bar-chart/
May be one of these others then? http://peltiertech.com/WordPress/trellis-plot-alternative-to-stacked-bar-chart/
Hui Excel Ninja Staff member Dec 24, 2013 #5 A Simple Column Chart will show the relativities and values easily
sreekhosh Member Dec 24, 2013 #6 Thank you Hui...I think if we are arranging our data in Descending order, Column Chart is More Conveyable. Regards Sreekhosh
Thank you Hui...I think if we are arranging our data in Descending order, Column Chart is More Conveyable. Regards Sreekhosh
oldchippy Active Member Dec 31, 2013 #7 Hi sreekhosh, This might be a good one to keep for future reference? http://www.datapigtechnologies.com/downloads/Visual_Guide_To_Choosing_Chart_Types.pdf
Hi sreekhosh, This might be a good one to keep for future reference? http://www.datapigtechnologies.com/downloads/Visual_Guide_To_Choosing_Chart_Types.pdf
E Eric M Member Jan 23, 2014 #8 100% Stacked bar chart or if you have a bit of time, panel bar charts.