柱状堆积图(国外英语资料).docVIP

柱状堆积图(国外英语资料) EXCEL diagram provides a simple stacked bar chart,, but in practice often need to make a chart contains stacked bar chart chart, a simple method of making the stacked bar chart cant meet the need. The following is a people in the actual use of several kinds of commonly used the method of making the stacked bar chart, some methods are not necessarily the best solution, hope to be able to play the role of the topic 1, a single cluster of stacked bar charts: is EXCEL charts in the bar chart of the second option, there is nothing special about this chart, you just need to step by step according to the chart wizard to make complete 2, two overlapping clusters stacked bar charts: using the chart of the main axis and coordinate from Settings, and combining the data series format Settings, and in a chart, two stacked bar chart clearly Method: (1) create a stacked bar chart with a chart guide, which contains the entire series of two columns (2) in the format of the data series, the spacing width is appropriately adjusted to make the column graph wider (3) used to make the second selected the several data series of stacked bar chart, the data series format - axis, select the axis, in the time axis to form clusters of bar charts (4) to select a series of coordinates in the coordinate axis, right-click the chart type, and change it to stacked bar chart. (5) choose the coordinate axis, right-click to clear, and make the chart show only one axis and keep the unit of the main sub-axis consistent (6) when setting up the data series format, the main coordinate axis is compared with the bar chart on the secondary axis by setting and adjusting the color pattern [this post has been edited by the author in 2004-7-16:30] Attachment: your user group cannot download or view attachments You can help me with the learning while you study TOP fieldsun Honor the webmaster integral 8433 wealth 12317 RMB share 0 flowers 0 technology 38 Registration time The 2002-10-14 Total score r