a. The standard defines the attribute chart:stacked This attribute is supported in Microsoft Excel 2013 and later. This attribute applies to the style of the <chart:chart>, <chart:plot-area>, and <chart:series> elements when the series type is line, area, or bar. English (Sout...
if Y2<0 then Z=Y2; else Z = Y1+Y2; Now plot Z first, so that it is in the background. Plot Y1 next, which will put it in the foreground and "cover up" the portion of Z that you want to hide. You can either use the VBAR statements that @mohamed_zaki proposes (but use ...
show your entire code and some example data to show the result you get and hopefully some way to show what you want to get (image is fine PNG, GIF what ever, Excel not so fine) Order of statements in the template, order of data and data values may have some pretty complex ...
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting...