how to prepare chart ?

Report Inappropriate Content · ‎2016-09-26

Hi All,

could you please help me to prepare below chart.

SAMPLE DATA IS :

	Year 1	Year 2	Year 3	Year 4	Year 1	Year 2	Year 3	Year 4
CUMULATIVE	ORDERS	ORDERS	ORDERS	ORDERS	SALES	SALES	SALES	SALES
A	25,963	42,790	56,874	71,190	20,33,639	34,64,726	45,06,359	54,38,038
B	30,713	55,680	75,977	92,477	18,59,421	39,82,751	54,83,717	65,44,741
C	29,761	47,149	61,694	76,258	23,12,625	37,64,714	48,22,920	57,60,811
D	32,200	56,872	75,777	90,262	18,27,132	38,87,611	52,60,487	61,75,222
E	33,957	57,362	77,405	96,898	23,29,230	43,15,457	57,94,804	70,57,418
F	33,529	61,274	84,233	1,03,231	17,76,450	41,30,963	58,25,161	70,44,225

Anil_Babu_Samineni · ‎2016-09-26

Would you provide the Excel?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sunny_talwar · ‎2016-09-26

Sales and Orders are on the same chart? Wouldn't that be too confusing?

sudeepkm · ‎2016-09-26

you might try using a trellis chart for multiple products but you have to either split axis or present Orders and Sales separately as their scale varies. Given below are snapshot of both.

with Split Axis:

Related Topics