ffff<span><img width="800" class="chimg_photo" alt="2.jpg" src="http://thimg.todayhumor.co.kr/upfile/201601/1452047185E7iCyNF6Q9EnhI.jpg" style="height:auto;border:1px dotted #FFA500;"></span> <div style="margin:0px;padding:0px;max-width:100%;"><span> </span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>              <br>            List<string> Name_List1 = new List<string>();<br>            List<string> Name_List2 = new List<string>();<br>            List<string> Name_List3 = new List<string>();<br>            List<double> Count = new List<double>();<br>            List<string> StrSelect1 = new List<string>();<br>            List<string> StrSelect2 = new List<string>();<br>            List<string> StrSelect3 = new List<string>();<br>            List<double> strSum = new List<double>();</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                    Graph_Name1 = "지역";<br>                    for (int index = 0; index < 성.Count; index++)<br>                    {<br>                        for (int index2 = 0; index2 < 지역.Count; index2++)<br>                        {<br>                            expression = Graph_Name1 + "= '" + 지역[index2] + "'";<br>                            var Graph = (from dr in LowData_Graph.Select(expression).AsEnumerable().Distinct()<br>                                         group dr by new { Name1 = dr.Field<string>("F/M"), Name2 = dr.Field<string>("성"), Name3 = dr.Field<string>("지역") } into gg<br>                                         select new<br>                                         {<br>                                             Name1 = gg.Key.Name1,<br>                                             Name2 = gg.Key.Name2,<br>                                             Count = gg.Count();<br>                                         }).Distinct();<br>                            foreach (var x in Graph)<br>                            {<br>                                Name_List1.Add(x.Name1.ToString());<br>                                Name_List2.Add(x.Name2.ToString());<br>                                Count.Add(x.Count);<br>                            }</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                            DataRow[] Select_Data = LowData_Graph.Select(expression);<br>                            SelectTable = LowData_Graph.Clone();<br>                            foreach (DataRow dr in Select_Data)<br>                            {<br>                                SelectTable.Rows.Add(dr.ItemArray);<br>                            }<br>                            c.Header.성s = new string[] { "집계" };<br>                            c.Series.Add(new Steema.TeeChart.Styles.HorizBar());<br>                            c.Series[index2].Marks.Style = Steema.TeeChart.Styles.MarksStyles.Value;<br>                            c.Series[index2].Clear();<br>                        }                        <br>                    }</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                    for (int i = 0; i < Name_List1.Count; i++ )<br>                    {<br>                        Name_List3.Add(Name_List1[i] + "/" + Name_List2[i] + "/" + TimeSum_List[i].ToString());<br>                    }</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                    List_Distinct(Name_List3, Name_LowList1);<br>                    Name_LowList1.Sort();</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                    for (int i = 0; i < Name_LowList1.Count; i++)<br>                    {<br>                        string temp;<br>                        string[] Array;<br>                        temp = Name_LowList1[i];<br>                        Array = temp.Split('/');<br>                        StrSelect1.Add(Array[0]);<br>                        StrSelect2.Add(Array[1]);<br>                        strSum.Add(double.Parse(Array[2]));                         <br>                    }</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                    int count = 0;</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>                    for (int i = 0; i < F/M.Count; i++)<br>                    {<br>                        for (int j = 0; j < 성.Count; j++)<br>                        {<br>                            for (int k = 0; k < StrSelect2.Count; k++)<br>                            {<br>                                if (StrSelect1[k].Equals(F/M[i]) && StrSelect2[k].Equals(성[j]))<br>                                {<br>                                    c.Series[count].Add(strSum[k], StrSelect1[k] + "-" + StrSelect2[k]);<br>                                    count = count + 1;<br>                                }<br>                            }<br>                            count = 0;<br>                        }<br>                    }</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span><br>//-------------------------------------------------------------------------------------------------------------------</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>        private void List_Distinct(List<string> DataList, List<string> Dis_DataList)<br>        {<br>            IEnumerable<string> distinct = DataList.Distinct();   <br>            foreach (string Dis in distinct)<br>            {<br>                Dis_DataList.Add(Dis);<br>            }<br>        }</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>//---------------------------------------------------------------------------------------------------------------------</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span> </span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>소스는 이런식으로 구성이 되어 있으며 </span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span><내용>의 경우 c.Series[count].Add(strSum[k], StrSelect1[k] + "-" + StrSelect2[k]); 을 찍어서 하나씩 데이터 나온것을 옮겨 적은 것입니다. </span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>그래프가 나오는게 A처럼 나오는걸로 예상을 했으나 .. 결과는 B처럼 나오더라구요.</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>아무래도 Series가 1이면 0이였던 제일 처음의 막대 다음에 그려져서 그런걸로 예상이 됩니다만.... </span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>B처럼 나오게 하려면 F/M과 성 2개를 기준으로 정렬을 한 뒤에 그래프를 그려야 하나... 싶지만 이것도 데이터가 어떻게 될지 모르므로 B와 같은</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span>결과가 다시 나오리라 생각됩니다... 이런 경우 serise값을 어떻게 해줘야 A처럼 그래프가 나오나요</span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span><br></span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span><br></span></div> <div style="margin:0px;padding:0px;max-width:100%;"><span><br></span></div> <div style="margin:0px;padding:0px;max-width:100%;">글 다시 올려서 죄송합니다 ㅠ</div> <div style="margin:0px;padding:0px;max-width:100%;">오늘  하루종일 머릴 굴려봐도 도저히 해결이 안되네요 ㅠ</div> <div style="margin:0px;padding:0px;max-width:100%;">series 추가 되는 부분에서 f/m 과 이름의 성이 같을 때 지역의 갯수를 체크해서 지역이 1개인것은 임의적으로 하나 더 series를 추가한 후 데이터는 0으로 넣어보려고 시도를 해봤는데 for문에서 지역의 갯수를 제대로 체크하지 못 해 이건 일단 낼 아침에 다시 해보고... </div> <div style="margin:0px;padding:0px;max-width:100%;">다른 방식으로 생각을 해본게 f/m 과 이름의 성이 같을 때 배열에 넣어볼까 생각 중 입니다.</div> <div style="margin:0px;padding:0px;max-width:100%;">이런저런 방법을 생각해보고 시도해보는데 후...</div> <div style="margin:0px;padding:0px;max-width:100%;">쉬운것 같은데 너무 빙 둘러서 생각을 하고 있는 느낌도 드네요.. </div> <div style="margin:0px;padding:0px;max-width:100%;"><br></div> <div style="margin:0px;padding:0px;max-width:100%;">해결될때까지 집에 가긴 그른것 같습니다 ㅠ실력이 안되니 야근하는 날만 늘어가네여 ㅜ </div>