Graph/chart options for 5 years of monthly data points for 40 departments

[broken keyboard]

Hi all,

I am trying to figure out how to best visualize 5 years of monthly data of sales figures across 40 departments, where the goal is to find trends in a given month-year combination for a department (and perhaps ideally, comparing across the 40 departments for the 5 years of month-year groupings).

I've copied below what the format of the data looks like, however my table below is limited to just 10 columns across and 10 rows down. In reality, there are 62 columns and 41 rows formatted like the below to represent the 40 departments and 5 years worth of monthly data.

Any ideas greatly appreciated - if possible to see what this could look like in an Excel file, even better, although I'm not sure if Excel files can be uploaded here

Name of Department	May-18​	Jun-18​	Jul-18​	Aug-18​	Sep-18​	Oct-18​	Nov-18​	Dec-18​	Jan-19​
Department 1	23964​	20646​	24365​	32178​	24759​	33350​	32518​	46179​	46435​
Department 2	25855​	42438​	29039​	21197​	25242​	21794​	44018​	41478​	30223​
Department 3	40395​	21236​	24692​	29936​	35040​	49422​	24524​	21700​	49510​
Department 4	29649​	24425​	27949​	34153​	30890​	32665​	47608​	25654​	27962​
Department 5	34885​	39233​	37701​	32478​	20877​	24008​	29007​	26024​	40210​
Department 6	41046​	41599​	24785​	45823​	48509​	33838​	30322​	37852​	27310​
Department 7	30597​	21640​	41414​	27725​	34261​	44875​	49255​	43319​	35779​
Department 8	32535​	36295​	34752​	21873​	34947​	26057​	28438​	23848​	42617​
Department 9	30196​	49033​	32503​	31814​	47739​	24721​	47452​	48510​	22483​

 

[Drrellik]

XL2BB - Excel Range to BBCode

Convert selected range to BBCode to include as a snapshot in your question.

www.mrexcel.com

you can post a portion of your worksheet using this free add-on

 

[broken keyboard]

Hopefully the below worked!

Data example to be charted or graphed.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
1	Name of Department	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23
2	Department 1	23964	20646	24365	32178	24759	33350	32518	46179	46435	34038	47696	45032	26416	35452	31459	32557	46235	40223	37313	22230	35697	24519	45674	22521	25865	33192	39685	38652	48231	22252	41170	30119	46187	23796	24716	25196	44919	47431	22415	31294	33769	33656	37489	38682	29604	41637	21370	21785	40245	43862	38274	35330	24622	24825	31832	22170	31312	49261	33453	25682	22265
3	Department 2	25855	42438	29039	21197	25242	21794	44018	41478	30223	40027	23959	42067	39111	46465	22128	41734	40043	35098	24511	35194	33564	41699	34896	40666	35752	49873	41914	46300	37328	28154	41478	23697	42829	38813	32844	24753	20235	30970	46922	42360	40832	48915	45641	34830	32702	21330	33742	35501	25606	31598	33697	22874	42759	30419	45893	24175	27289	39465	20020	37957	36684
4	Department 3	40395	21236	24692	29936	35040	49422	24524	21700	49510	48975	24354	34213	23129	25112	29174	28479	32958	46365	41390	22030	25397	47988	33823	38244	45156	30490	23575	41565	22757	44132	30448	39772	34304	29397	20406	26470	42334	22026	36795	31400	41400	46331	46987	44719	34140	34955	39546	28873	38729	30894	26114	48982	39216	31507	38762	33931	23653	46803	40319	44095	25541
5	Department 4	29649	24425	27949	34153	30890	32665	47608	25654	27962	22921	40013	36842	21920	32400	48171	45625	49839	41717	25560	35342	23821	43023	31495	38237	46610	40654	33631	35454	37449	20576	25326	38065	37765	46695	40311	45116	45154	39478	45875	26386	45734	30541	27058	41773	27195	27002	39912	26109	23712	26450	46589	44712	26045	27655	25103	42000	24258	29009	38150	41961	46314
6	Department 5	34885	39233	37701	32478	20877	24008	29007	26024	40210	48774	35533	43929	43439	30726	21730	33320	30353	45616	40452	28495	31531	46536	41310	26273	39233	42864	43132	22624	34174	33423	45545	20699	29487	49510	33425	36452	40733	33071	36678	34010	40058	22012	42202	26194	26877	25772	24092	36360	49619	39568	49905	33350	31893	26497	36026	42714	27249	21197	37312	30570	45158
7	Department 6	41046	41599	24785	45823	48509	33838	30322	37852	27310	21024	29412	29029	47280	28281	27391	41044	28829	24054	34670	32873	22898	41103	45953	34238	49429	42268	29781	32314	36664	20048	34259	31586	40769	41206	33352	37147	22767	24904	49740	27953	36182	23107	41959	31195	33153	40416	43355	26576	37196	20970	37935	41483	31201	37088	42880	48945	47225	35120	45563	48858	44524
8	Department 7	30597	21640	41414	27725	34261	44875	49255	43319	35779	48515	20675	20298	34392	31820	27694	26839	24082	28173	35114	28636	46365	37629	31451	32522	32799	21584	23827	43823	29804	46479	34299	20023	25402	37989	34575	32005	23489	49639	46202	35384	23446	35763	40226	44934	27047	25823	26891	33239	25157	20960	34251	26196	40509	46707	46528	43123	47467	26736	34379	26656	24468
9	Department 8	32535	36295	34752	21873	34947	26057	28438	23848	42617	28555	26657	27649	25938	37569	31193	31664	46783	25724	46263	41754	42147	40258	43623	31216	28292	40713	46582	20748	32100	39963	21235	34349	39777	22106	37336	32512	39632	30077	41199	45570	35690	33253	31461	46529	41065	37807	45461	32957	22871	25584	41307	45053	33127	27825	25628	23791	45597	35517	24880	44713	28847
10	Department 9	30196	49033	32503	31814	47739	24721	47452	48510	22483	26660	27703	34641	23627	27038	45746	43915	49704	48629	42571	26052	44448	22916	48963	36067	21046	44046	24055	26485	42815	24293	44957	46895	45455	28801	48633	41175	23061	36551	22706	33695	31242	35049	28654	35404	24752	27426	28788	47714	30092	34278	32561	35539	36419	21875	32841	29029	23350	46544	26521	44690	40851
11	Department 10	24465	48923	24917	47628	44605	22888	29382	48557	46368	32277	41100	27532	36108	42858	38357	35413	45240	46635	43205	36672	38014	33677	36083	25303	34950	48193	24893	39717	37121	45775	36302	42893	26363	20425	36005	39368	37894	41785	24399	28558	35602	24184	20960	46622	49622	20706	37460	26427	30205	31889	28273	25550	41205	37341	25577	27234	34839	31140	43441	44758	36418
12	Department 11	23019	32514	46502	28873	44186	35007	47137	23601	40514	45374	33840	46870	20402	25565	30555	36172	34483	22309	22111	31101	21693	47289	27085	25524	26553	35247	48264	38835	49609	39547	48371	22873	32966	36430	35550	43579	22921	30347	37657	25037	29208	24982	47019	25088	26556	26496	43414	35237	39574	35152	33898	24752	43054	42570	22473	22833	40357	36439	32354	20175	34099
13	Department 12	32939	47602	35719	41887	47781	34356	40058	34890	21539	45637	27374	44669	36872	27773	32552	49665	47253	44965	42751	24601	25521	48952	22719	29982	43196	37159	40601	28095	39171	48248	27073	36632	39498	28008	48391	23164	33141	21438	45618	46260	42737	22108	25301	40976	47472	34629	37345	44296	22347	29854	22880	45067	49980	41752	40167	49413	33574	26103	45955	24244	28528
14	Department 13	28609	24679	24810	23427	43586	27034	37343	29217	21028	49830	40158	26751	41153	20082	45659	21945	21720	20688	31269	25616	34114	21446	49001	35199	30793	46940	39137	48807	29721	35608	47586	20205	32317	37502	21289	23820	21699	45139	25321	31471	20806	27013	42348	41072	48640	37850	36033	33037	38340	44753	34286	28610	45517	35182	36974	43687	41846	24218	28906	29390	20726
15	Department 14	27063	35908	34538	48892	42241	43847	28182	41612	45706	38027	39165	45575	21118	26033	40699	22322	22931	25662	23023	30398	22385	47264	27379	41851	43274	49371	24562	45221	28507	49288	46902	48365	29692	42879	26984	32575	40607	31879	30227	23882	31804	46493	20636	33508	38805	41313	25498	34489	36041	33654	21529	36525	35885	37391	35967	36879	29460	33668	28870	38576	35143
16	Department 15	46065	32031	24207	26093	39467	44716	30174	30057	33967	31846	23681	38642	38948	20599	44368	47556	27175	23313	39768	44808	42021	43654	40543	27227	36438	36731	38228	27888	23288	34898	43604	46743	34443	25876	40945	25095	22780	36964	35734	38448	33202	36752	27865	25462	33307	23266	34123	24044	26429	32020	31019	35072	22351	30282	28239	27199	42949	22622	45683	41616	43325
17	Department 16	48338	21314	47063	25803	28178	28033	29415	37766	36390	38431	28284	20499	27277	46861	38776	33978	36714	46463	46396	25253	49217	34044	33158	48365	20500	24791	21324	28333	43070	28206	40414	21551	41519	38407	31250	22026	45237	26164	49431	38813	34412	44645	42685	43403	41050	30063	42006	44317	24510	41177	46353	43782	30066	37081	24164	24634	33136	30346	23490	31097	21866
18	Department 17	25498	27052	47125	20828	43350	46572	49325	36596	30957	41334	21348	32493	43634	47917	34563	34552	28265	33592	48857	35131	20583	37374	46935	37689	46430	43734	47925	47041	36201	24087	40321	26331	20629	36464	39619	48977	22670	23648	34197	47596	36047	47163	44964	41437	24871	31023	32812	24225	37489	42355	23568	33991	23278	44823	33601	41500	32523	45387	44186	23926	26326
19	Department 18	33447	32534	37831	43580	45776	46000	38470	43586	37166	45178	48457	22013	30915	42008	38685	37270	20922	45142	32721	47536	28842	41476	34152	37207	46050	44992	28752	42513	34673	38559	32566	23820	26380	43190	28366	43505	39668	28249	22934	40548	28878	25198	20935	47894	24018	24340	33697	42262	22337	46256	39026	28075	33490	36722	41843	35262	38576	48311	26691	34473	21267
20	Department 19	37849	22550	44114	35230	22676	20801	46531	44007	25637	21513	32002	48499	37210	49845	47871	45786	20206	37836	40569	25862	45908	49530	38547	41871	28449	32965	45102	40423	34931	36509	41761	40659	46674	27550	34665	29190	31039	42770	23195	27619	26190	43711	33687	28676	43499	34300	21156	22839	47544	48436	25981	27885	23169	25313	38941	41786	34624	46195	46348	40923	39853
21	Department 20	25468	46523	44563	22619	27567	25139	32235	44702	31781	45793	42016	27146	39202	36296	40273	26769	32795	34779	29739	41544	26222	31517	34085	47538	30932	45903	30597	26261	38103	48837	24137	33073	38619	29570	22350	41426	27121	46407	24486	32843	42175	37495	41377	24310	49351	25278	20076	35457	42284	29348	35691	29649	44016	26369	48269	38942	32730	39485	39721	34553	24278
22	Department 21	43733	31080	37624	20880	25758	43547	37520	29312	29852	43303	40280	44646	36309	25962	22724	20242	38360	43888	44270	25092	29225	43956	48222	26002	30930	41347	38783	37587	46613	31106	38212	33736	32902	40322	29806	43954	48796	30673	45948	36713	26338	27381	31402	41643	42993	34107	22911	28706	49589	28813	46759	21606	37293	48815	37299	21607	37515	44122	31995	41803	28036
23	Department 22	36709	45142	33896	41377	28358	20182	32470	26280	48565	31929	41245	46935	26310	38279	36852	42946	45940	20708	47999	37216	30800	25004	39232	48370	36685	44065	43727	34203	47282	32669	35698	27095	27455	20755	29079	25769	22131	45019	28012	27123	35094	31151	44970	45578	46665	45200	37348	46180	24025	43468	30256	30088	42493	26924	40503	49671	31511	41178	24009	27379	21386
24	Department 23	48504	47140	22714	27509	22410	20552	45956	46322	22031	49220	28817	25761	25747	44989	46446	27535	49007	33762	49951	25874	29545	33461	27439	28590	23176	43318	47871	40594	27640	44120	31507	48317	31528	38332	23855	21725	45098	37566	48520	37639	31301	25834	30426	36309	30338	32344	31338	49096	35197	35825	46815	30929	29958	31652	47617	47418	40296	32106	21962	29078	36449
25	Department 24	41653	24893	35247	25235	35368	25322	49610	34180	40842	22096	28859	39936	42313	22851	42049	29668	26247	37070	41673	48410	44049	38858	26130	33108	40070	23601	43531	35083	38582	41647	49199	33081	44079	31902	40601	32994	38955	43763	24256	47725	37542	45521	48922	29689	46875	32817	30717	34537	23384	31567	39558	29194	25437	46381	27326	39043	36807	39468	42923	20572	22233
26	Department 25	38356	45296	45933	24263	25735	22939	43433	39845	24184	43077	23370	25491	30678	23392	35901	38214	24321	20164	49403	26774	32860	28545	41664	41901	25284	36021	41915	23316	32876	26618	22900	49866	25160	24917	25686	47717	47377	22618	30453	30713	36046	35208	25535	45332	38096	49164	39319	36382	26335	44159	28382	42705	36545	37308	46324	49253	46869	30055	48307	47486	29096
27	Department 26	42429	27735	41359	44984	48131	46235	33651	35176	33261	42953	28376	48757	38675	31564	47082	36981	43847	31097	26491	47531	29610	24507	33698	38623	24448	41146	30174	48130	46171	39026	34984	40700	46064	48733	28027	37280	34696	29382	33204	42600	25256	38535	37264	39479	36229	32854	39629	34185	43023	38009	43282	44666	37781	45590	22557	43455	26052	28078	48059	40061	33920
28	Department 27	48651	37930	20461	25012	37758	43318	44620	37226	31050	26629	23955	38699	43556	45581	37010	23559	34010	35469	24770	39848	29263	40106	36823	34976	30273	29527	30375	44070	33043	27966	48834	28704	35482	25385	23575	36936	26728	43871	32963	36224	38909	38691	24278	32473	22918	32580	29638	25590	48246	42624	43596	38592	43985	31329	28683	31339	49845	32417	32157	40000	29116
29	Department 28	28480	34001	41900	39943	20206	35094	38388	38791	49971	32131	46458	45577	21804	30310	24875	31076	44895	24033	45721	24768	31113	41600	41871	25796	25739	33743	32508	39456	48629	38165	28610	40865	33714	41551	43361	42209	25159	46312	26664	35103	37907	23194	33684	41213	32035	38302	20271	23064	41802	29804	31418	33346	29586	49934	36281	22550	41022	39917	20793	35176	23573
30	Department 29	31658	21155	43152	36495	49312	33994	28367	37960	35259	38914	48354	49224	22956	20286	25385	32820	22904	32811	29305	48158	42551	22643	36490	42692	38005	41543	22524	20619	26141	48355	45903	41512	24813	35816	23428	34024	34446	44359	30632	23811	42055	22187	24518	48514	24686	31090	32619	31616	24028	27872	39121	33718	28158	31374	32076	22203	28927	25536	41099	32689	46529
31	Department 30	36473	34732	31201	43795	40496	27846	47525	29924	31203	47068	48234	32971	35995	37686	33339	48750	47124	45650	27849	45739	21372	35770	32168	28549	25097	42807	48944	38971	23695	20200	45097	27805	38266	25111	25951	32000	32071	20874	23173	45444	31601	35658	33560	47189	47367	23260	34434	42870	41859	39378	41586	37319	28407	20181	37011	24927	39701	29721	36352	37608	38457
32	Department 31	47123	43920	40328	43771	26166	29766	23710	33050	46938	23519	24391	33079	24450	35218	35435	26885	39507	30212	49224	25329	35476	28857	33186	40807	35080	47986	34941	35503	24393	34290	37844	20674	27762	37396	27411	22564	35976	44245	41405	35008	37294	20245	35839	44434	48378	40892	22866	33055	27546	30235	47223	28264	31611	25861	38474	32941	38530	25125	28449	29189	38836
33	Department 32	30886	24711	29311	30373	45444	46944	45432	28722	22367	44757	28054	33569	45955	46074	49321	38810	32845	24127	24473	46329	27061	34393	40810	28817	40764	31275	28692	22774	22391	41324	24129	25166	22000	42151	22722	29356	33288	34635	41761	47911	29936	36336	26809	48339	23539	41404	33712	33427	41758	20311	43473	25433	25627	33469	27443	23947	21942	40439	25283	35330	42526
34	Department 33	43028	41531	46385	42995	39336	46815	35859	30176	29620	22480	38900	21398	31591	32071	20398	44969	41689	27459	22261	43778	37176	26191	25952	45157	49560	38427	45460	33242	23226	43810	25387	48381	48241	40575	29886	48632	45807	24945	47487	28366	38853	49411	46957	38656	34709	34137	29672	47754	42787	38984	38922	24885	23943	33761	40771	47945	42911	32695	38245	39443	20752
35	Department 34	38337	35560	49968	41345	35194	29676	44626	41279	27716	37121	38605	48640	28132	28114	36763	32842	23414	20007	35899	34201	42658	28365	25655	32780	39847	29091	37189	31969	42043	32803	29039	35359	36410	25281	41483	27247	39754	30581	44741	45561	36619	44350	21197	34750	43133	44007	27531	48306	21144	33868	39957	47569	24474	44247	32527	21784	35148	45546	29463	45635	43024
36	Department 35	48164	29240	25261	45116	38544	40119	29953	29460	42829	43117	48565	38449	26584	40216	22916	43573	36352	40967	32432	34630	20256	41606	48705	43222	25847	22360	26762	33931	44074	46194	40124	21908	24964	46938	27287	27956	40061	21418	37613	26626	49913	36701	26464	48472	27434	36523	38692	42610	39863	44939	24771	41435	43908	40027	40806	49100	26618	30091	27304	28491	43295
37	Department 36	26392	37727	49421	46242	45913	23092	44430	38127	46428	22827	31193	28135	47384	39633	31305	48378	41565	37587	47461	26953	30308	33577	24449	29014	33365	38212	36965	27118	47659	22028	20864	37696	34102	30966	41165	40450	49810	46962	20003	48434	34370	41603	25174	20333	23601	44911	49427	34710	41498	38921	24517	47599	22720	41045	20759	38896	41614	32977	31349	21024	35756
38	Department 37	29570	38707	21948	21846	40183	42706	24179	39399	41864	23254	26906	46955	39183	38946	30001	26364	43298	44173	49933	34418	26805	22317	30737	21073	42588	42534	31087	28117	26228	26431	34076	34777	46012	36832	32057	26582	22478	35096	45261	21259	39826	43678	28969	41551	40154	43454	43325	28480	25060	36742	20883	25384	36613	27714	25273	24472	40549	41766	29550	22541	26331
39	Department 38	34932	21929	32227	22464	24396	20076	47370	46876	46504	29497	23267	42329	48174	36565	33793	38799	20818	47042	34604	49014	47648	31398	47270	44616	28396	32205	46443	23417	27992	27870	32810	24361	36970	26717	26521	48159	25871	36754	42668	36664	38097	30268	30263	42257	25766	30235	37969	27344	27815	33616	25431	21808	46642	46009	49602	20537	23634	26655	45536	29793	39013
40	Department 39	42748	49692	28589	22636	33738	48709	38270	49828	28774	20685	26192	44819	34034	40856	27351	48444	20886	21915	24514	40256	38266	38411	38668	33687	44986	48341	48018	43637	25140	27224	43244	26652	43119	29662	30196	45612	43906	44249	20286	28125	32961	36812	27651	38878	25546	27569	46757	32582	42467	46206	32194	23733	31401	31136	39666	35023	34965	22383	35105	48543	33713
41	Department 40	42661	43570	31857	42393	21564	35559	49372	20480	30245	26938	33066	26258	34707	48249	41250	41076	25830	43360	34094	23413	39680	20171	22526	23227	38313	39629	37000	31758	45110	43122	34142	41460	39220	47608	26025	36631	23603	35659	24426	41270	24565	27338	22697	35022	34152	21999	37007	23828	47828	44500	30941	48409	22318	41585	48524	31318	39477	26736	49872	40354	49715
Sheet1