Скачать с ютуб Make a Clustered Stacked Chart in Excel в хорошем качестве

Make a Clustered Stacked Chart in Excel

✅ Get the sample Excel file to follow along: https://myctx.link/ChartCS 🔵 Excel doesn't have a Clustered Stacked chart type, but you can build one yourself, with a cluster for each region, and a stack for each year. This short video shows how to set up your Excel data, and build the chart. Then, make a couple of quick formatting changes, to get a clustered stacked chart. 💡 Related Links 💡 Clustered Stacked Column Chart ► https://myctx.link/ChartCS Clustered Stacked Pivot Chart ► https://myctx.link/pivotstack 🔴 Related Excel Videos 🔴 Clustered Stacked Pivot Chart ►    • Create a Clustered Stacked Column Piv...   Add Pictures to Pie Chart Slices ►    • Add Pictures to Excel Pie Chart Slices   Compare Years in Excel Pivot Chart ►    • Compare Years in Excel Pivot Chart   ✅ Excel resources I recommend ► https://myctx.link/xlpick ⏰ Video Timeline ⏰ 00:00 Introduction 00:19 Cluster Stack Chart 00:40 Data Layout 01:52 Make the Chart 02:32 Format Chart 02:58 Change Colours Instructor: Debra Dalgleish, Contextures Inc. More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu... #ContexturesExcelTips VIDEO TRANSCRIPT In this workbook, I have: sales data for two years, for four different regions, broken down by season. I'd like to create a chart like this one, that shows each of the regions, with a stack for each year and the seasons broken down within each stack. This is Debra Dalgleish from Contextures.com. This chart that I want to create is like a combination of a cluster column chart, and a stack column chart. So we've got clusters for the regions and stacks for the years. There's nothing built into Excel that will do that so I'm going to copy my data to a blank sheet, then change the way it's arranged. To start I'll copy the columns with data (I want to leave the original data unchanged) Copy that, go to a blank sheet and paste it. To get the data ready for the chart, I'm going to add some blank rows. I want a blank row before the first region and then a blank row after each region. A quick way to rearrange my data is to put some numbers down column A. I've got four regions and I need three rows for each region, so I'll select and copy this, then paste it twice. I want a blank row at the very top, so I'll type a zero here. I'm going to select those numbers and all the data that I have, and then sort those A to Z, so data A to Z. Now there's my blank at the top, and each region has its data in one row and then two blank rows after that. All I have to do now is select the second year of data and drag it down one row. So, we've got blanks, two rows of data, another blank, and this is how we need it to create our cluster stack column chart. I'm going to select starting in cell B2 above the region headings here; select all the headings and down to the last row that I've got numbered there, so I want to include that blank after South, and then I'm going to insert my chart. Go to the Insert tab, and I want a column chart, a stacked one. Click that, and there's the chart. Because we've got these blank rows, we've got East has its first year of data and then its second year, and then there's a blank where the third row is empty, and the same for each of the other regions. Now to make these look more clustered, I'll do a little formatting. Click one of the segments, and on the Format tab, Format Selection, and I want a gap of some little number, so I'll put 20 here and now it's looking more clustered. There's a bigger space between the regions than there is between the stacks for each region. The final thing you could do to make this look nicer, is to match up the colours. Right now, winter for both years is blue, but you could make this a different shade of orange. So if I go to Format and choose a lighter orange here and do the same for the grey and for the yellow, and now you have a cluster stack chart and you can compare year to year totals for each region