柱状堆积图（Column stacking diagram）.docVIP

柱状堆积图（Column stacking diagram） Note that the primary and secondary data series number of axes should be equal, otherwise the histogram of the width will be different, if the number is different, need to add up the empty data series (in series at the input value {}, 4 more than two layers of stacked column Liezi) (3) select the data series of the sub coordinate axis in turn, and change the coordinate axis into sub axis in the data series format (4) according to the result, the sequence of the main and sub coordinate axes of each series is adjusted respectively according to the data series format and series order, so as to adapt to the requirements (5) clearing the secondary axis [this post has been edited by the author at 2004-7-7 16:29:39] Attachment: your user group cannot download or view attachments You help me help you side by side with the fly TOP Fieldsun Honorary moderator integral Eight thousand four hundred and thirty-three wealth 12317. share Zero flower Zero technology Thirty-eight Registration time 2002-10-14 Total points ranking Sixty-nine Send a short message Plus a friend? 3 floor, small and medium-sized published in 2004-7-7, 16:28 only to see the author * essence in essence: to become the Excel master shortcut. Step by step Excel video tutorial to teach you to start free. 4, more than two stacked stacked column diagram Due to the use of a chart for the primary and secondary column axis overlap can only form the two layer column accumulation effect, of three or more stacked charts, I used two or more charts overlap combination in practical implementation, the multiple charts of all the same size on the stack together, overlapping form a graph (which may have a better way, please think of) Making steps: (1) to determine the maximum value of the series of accumulation, plus auxiliary row (or column), the maximum value will be expanded into a series of charts in second (because the first chart has the maximum value, whether to increase this value is not