want ticks on excel 2016 for mac horizontal axis for every third year

#Want ticks on excel 2016 for mac horizontal axis for every third year series

#Want ticks on excel 2016 for mac horizontal axis for every third year series

Delete the dummy data series from the legend.Second, move the category axis to the bottom. Right click the right vertical axis -> Format axis -> Axis Options -> Position Axis -> Horizontal axis crosses: -> Automatic.Right click the vertical axis on the left -> Format axis -> Axis Options -> Position Axis -> Horizontal axis crosses: -> Maximum axis value First, move the axis on the bottom to the top. Move the category names to the bottom of the chart.Right click chart -> Select Data -> Select the dummy data series (left pane) -> Click edit (right pane) -> Highlight the category names Set the Horizontal Axis Label for the dummy data series into the category names.

Layout (Ribbon) -> Select the dummy data series -> Format Selection -> Plot Series On -> Secondary Axis (if you are having trouble selecting the dummy data series you just created, just change the values to something so that it can be selected, and change it back after you are done this step)

Set the dummy data series to the “secondary axis”.

Right click on chart -> Select Data -> Add -> Series values -> Highlight a number of cells based on the number of categories in chart (just 4 in this example) Up till now, we have something that looks like a stacked clustered chart, but need the x axis to have the right category labels, grouping the stack bar charts.

Change chart component sizes (optional).

Fix coloring to desired colors (optional).

Re-order data source to desired order for bar chart (optional).

Right click bottom horizontal axis -> Format axis -> Axis Options -> Position Axis -> On tick marks

There should only be half a gap before and after the first and last bar respectively.

Eliminate all gaps by right click bar chart -> Format Data Series -> Series Options -> set Gap Width to 0%.

Highlight the copy of the data, and create chart by Insert -> Column Chart -> Stacked Chart.

The second stack is 1 row down from the first stack. This is how the cells should layout in the cluster stacked table.