excel make triangle stacked bar chart table
1, as shown in Figure 1 below, is the original data in this case, in order to form a symmetrical bar chart, you need to add the auxiliary columns, as shown in Figure 2 below, the auxiliary columns 1 is a set of data with a value of -200, it is in order to separate the two contrasting columns of data divided auxiliary columns of data, the other set of auxiliary columns is the second column of data Inverse data, the purpose is to form a contrast on the vertical axis.
2, as shown in Figure 1 below, in addition to the third column of data, select the remaining columns of data, insert - stacked bar chart, get the following figure 2.
3, select the middle of the auxiliary columns, set the fill to "no fill", get the following figure.
4, Insert - Shape, select the shape of the triangle, draw two triangles, a positive triangle, an inverted triangle, respectively, filled with a good color to fill the bar chart (in this case, blue and orange), the first to select the positive triangle, Ctrl + C to copy to the clipboard, and then select the data located in the positive axis, right-click to set up the data series format, fill set to fill the picture with the texture fill, select Source is the clipboard (shown in Figure 2), the same can be drawn on the negative axis of the data filled with good inverted triangles, get the following figure 3.
5, the chart area in the selected data columns, set the data series format - classified spacing - set to 45% or so, if you need to point of the three-dimensional effect can be added to the point of the shadow; set up the format of the horizontal coordinates of labels and axes of the distance is set to 30 or so, the main type of scale set to "none", get the following chart.
6, beautify the steps: move the legend to the center of the chart above the location, add a title, delete the vertical axis, set the drawing area is not filled, the chart area is filled with patterns (background white, foreground light gray), adjust the display fonts, and finally get into the figure, as shown below.
excel|
Excel Forms Tips Share (more related tutorials continue to be updated) Calculate Ranking Cancel Undo Setting Ranking for *** Enjoy Making Forms Making Barcodes Making Attendance Inserting Backgrounds Adding an Underline Using Macros Making Schedules Inserting Pagination Displaying Smooth Curves Inserting Columns Using Rounding Quickly Pulling Down Formulas For Batch SummationReplace Table StylesUse Subtraction FunctionRecover Unsaved ContentMake Logarithmic ChartMake Composite Pie ChartFilter DataFast Merge CellsPush Excel FileMulti-conditional FilteringFunctionSort Data by StrokesSplit Batch EditAdd Multiple ViewboxesWeChat Push FileIdentity Card No. FormattingSet UpAutomatic CalculationInput Id No. TipsImporting Web PageDataInserting CellsEndorsing NotesPutting Up Symmetrical Bars line graph get x-axis y-axis restore no save file input ID number Chinese characters set to pinyin often need to use tutorial data filtering function using filtering the same data table to convert numbers to uppercase amount word and excel separate text auto line feed use sum formula function plot standard curve chart print multiple worksheets do project file directory table according to the birthday to extract the Chinese zodiac sign merge multi-cells set up the text auto ... line feed increase the number of undo operations digital lowercase to uppercase semicircle bubble infographic enter key can not change the line surface graphic chart randomly move the chart position table can only see can not be changed automatically resize the word round thermometer chart to create a list of bubbles picture lowercase to uppercase formula unequal width of the columns of the chart using read-only way to open the one-variable equations solving to draw a beautiful combination of charts to make the regression curve to make the progress of construction table planes Right Angle Coordinate SystemMake Standard Curve ChartPlane Right Angle Coordinate SystemWorksheet Name for TitlePrint Only Part of FormDouble Layer Circle ChartTriangle StackingColumn ChartOne ChartDrawing Multiple CurvesPictureTable to ExcelCellMultiple Rows and One LineCompare Two ColumnsData Differences and SimilaritiesIconsData MarkersUse a Special PictureCompetitionSortingAutomatic Scoring SheetSetting the Default Number of SheetsChartColorsAnchorsLeveling AxisTextWord FormsTo Excel table accordion bar data chart click on the table text to learn more oh~