Change the values in the “Spacing” column to 0.
Excel 2016 for mac bar graph series#
On the chart select the Grand Total Series and right click so the “Fill” option appears. Change the “Label Position” to “Inside Base”. 
In the “Select Data Label Range” pop up box, highlight the values from the “Grand Total” column. Right click to “Format Data Labels” and change the “Label Options” to “Value from Cells”. Change the “Spacing” column values to a number (e.g., 1000) big enough to make a new category visible on the stacked bar chart. Select “Switch Row/Column” as necessary so the “Spacing” values are not listed as an option on the Y axis. On the “Insert” menu select a “2-D Stacked Bar Chart”. The “Spacing” column should have a value of 0 at this point. Highlight your data including the “Spacing” column but not including the “Grand Total” column. Add both “Grand Total” and “Spacing” columns to your data. The Keys to Adding Totals to the Stacked Bar Chart Above: Select the line, format the data series and change the “Line” option to “No Line” in order to leave only the totals and hide the line. Format the line’s data label, changing the Label Position to “Above”. Change the “Grand Total” series chart type to a “Line”, while leaving all others as a “Stacked Column”. Right click on the Grand Total and “Change Series Chart Type”, the viz becomes a “Combo” chart. Add “Data Labels” to the Grand Total series on the chart. Select the chart and then expand the data range to include the “Grand Total” column. Select “Switch Row/Column” as necessary so your first data column is listed on the X axis. On the “Insert” menu select a “2-D Stacked Column” chart. Highlight your data not including the “Grand Total” column. Add a “Grand Total” column to your data. The Keys to Adding Totals to the Stacked Column Chart Above: Top and Bottom 10 Products by Sales Using RANKX in Power BI
0 kommentar(er)
