Graph Issue

[hollis27]

having a strange issue with my line chart not plotting its point correctly. First off, the axis data is not even close and each line doesn't even make sense. I really don't do graphs very often...so any help is appreciated. I don't have any points in Feb19 that are over 1000, the only data point that increases significantly jan to feb is midwest...lowest data point is 87 but reads as 200 on the axis. I've adjusted the axis...nothing.

 

[etaf]

non seem right , can you use a share like dropbox/onedrive
OR use XL2BB to provide the data

Also the numbers are left justified, which usually means text , unless you formatted

 

[hollis27]

non seem right , can you use a share like dropbox/onedrive
OR use XL2BB to provide the data

Also the numbers are left justified, which usually means text

Regions_Detail	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
Southeast-MGMT	195	213	210	154	170	146	149	131	145	193	119	109	103	160	173	172	143	188	149	163	184	227	248	281	219	365	358	391	374	414	451	450	427
Midwest-MGMT	211	601	210	209	235	192	138	181	120	159	126	98	150	193	202	368	192	160	167	238	163	234	191	292	247	647	607	421	460	552	251	490	548
Southwest-MGMT	87	90	114	105	73	80	61	66	39	83	57	33	77	117	125	84	65	82	126	55	95	70	97	81	73	88	145	105	77	144	105	99	104
West-MGMT	163	144	165	99	108	115	206	147	105	107	70	35	150	146	90	122	113	169	143	116	118	194	172	114	105	205	229	186	201	233	230	226	277

 

[etaf]

i just plotted and get correct values , so not sure what you are plotting, i play and see if i can reproduce your results
Edit , your plotting a STACKED graph and not a normal line graph
have a look at the chart design > Chart Type
and change to Line option NOT the stackline option

this is the normal line chart

 

[hollis27]

i just plotted and get correct values , so not sure what you are plotting, i play and see if i can reproduce your results
Edit , your plotting a STACKED graph and not a normal line graph
have a look at the chart design > Chart Type
and change to Line option NOT the stackline option
View attachment 49981

this is the normal line chart
View attachment 49980

figured it had to be something silly....thanks for taking the time out of your day to look at this for me. really appreciate it.

 

[etaf]

you are welcome