如何在excel中创建使用多列和堆叠列的图形? [英] How can I create a graph in excel that uses multiple columns and does stacked columns?

问题描述

我需要一个具有多列并且也有堆叠列的图.这是一张有助于说明我在寻找什么的照片:图形示例如您所见照片中有两个图表.我希望它们成为一体，而我希望Stacked每个数据系列总共有2列.我希望前列的顶部堆叠有数据C3:C14和D3:D14，然后后面的列具有B3:B14.

I need a graph that has multiple columns and also has stacked columns. Here is a photo to help illustrate what I am looking for: Graph Examples As you can see in the photo there are two graphs. I want them to become one I wanted the Stacked there to be a total of 2 columns for each data series. I want the front column to have Data C3:C14 with D3:D14 Stacked on top of it, Then a column in the back that has B3:B14.

推荐答案

简单的答案是您不能这样做，所以您必须作弊.您可以上传电子表格吗?

Simple answer is you can not so you have to cheat. Can you upload the spreadsheet?

这篇关于如何在excel中创建使用多列和堆叠列的图形?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！