mxchen

Thanks, I found You set the data follows: Chart1.Value(I+1,J) > Chart1.Value(I,J) and Chart1.IniValue(I+1,J) = Chart1.Value(I,J) Then for each series I, Chartfx to draw new a box using the Chart1.IniValue(I,J) and Sum(Chart1.Value(0,J) : Chart1.Value(I,J) )

How do the chartfx take the chart.Value and Chart.IniValue to draw the stacked bar? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> If only one series, it is simply draw a box using Chart.Value(0,0) and Chart.IniValue(0,0) When you have more than one series, it is very complicated. it depends if there is any negtive values and the Value is larger than IniValue or not. I cannot figure out the rules. Any help will be appreciated. What I figure out is when you set chart.Value(I,J)=0 'here I>0 then the chartfx using chart.IniValue(I,J) draw a line. but if chart.Value(0,J) < 0 and chart.IniValue>0 you have a extra line on zero. Thanks