Excel Creation Help

[Rezunder]

Hello everyone

My name is Antoine and I am currently a intern in a shipping company in taiwan. I am not new to excel but I am far from being an expert. I was given a task that consists in creating a customer profile for our 60 biggest customers. The goal of this profile is to be able to show the trends of the customers across the months and the years. For example taking a look at where a certain customer exports the most in a certain month. Now I need help because I am out of ideas when it comes to organizing the data for it to be readable by someone that doesnt have much time or isnt a excel nerd. Attached is an image of a graph that is for the different commodities imported by a client across 2023-2024 and jan to dec. How would you advise me to present the data (Divide it by commodity in a graph or pivot tables. I am out of ideas guys anything is welcome


Thank you for taking the time to read this

 

[awoohaw]

Welcome to the forum.

With so many lines, I just see pasta noodles.
A Stacked Bar chart for each company (each segment being a month or year) may be a good idea.

This loses a clear month by month comparison between sectors but give a sense of the consistency as well as total impact.
(And many may find this as 'busy' as I find all the pasta noodles.)

You could probably make it more relatable by using a pivot table as your source, and insert timeline slicers for both the pivot and the chart.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		2023-06-01	2023-07-01	2023-08-01	2023-09-01	2023-10-01	2023-11-01	2023-12-01	2024-01-01	2024-02-01	2024-03-01	2024-04-01	2024-05-01	2024-06-01
2	Greater China	195	41	242	88	258	263	178	240	331	106	260	2	113
3	NE Asia	202	65	230	372	107	164	394	66	40	129	382	202	198
4	SE Asia	253	220	316	57	175	391	369	180	314	166	40	120	361
5	INPA	268	181	191	378	191	271	77	79	2	53	331	44	288
6	Carb	267	112	242	143	380	41	391	87	106	314	159	248	227
7	USEC	355	271	5	350	298	21	310	131	307	165	193	379	148
8	USWC	315	299	76	344	240	366	392	58	305	205	209	279	386
9	Baltic	355	382	364	31	290	155	370	179	111	31	331	279	326
10	NEUR	175	85	299	269	398	347	224	11	199	139	325	70	345
11	OCA	115	53	95	34	327	260	158	363	128	173	32	285	137
Sheet3