How do you make a column chart transparent in Excel? chart-like data, a beautiful chart can be more effective to convey information to the viewer, I would like to introduce how to make transparent column chart
As you can see from the diagram, the grid lines that follow can be seen through the columns.
1, select the data table, in the functional area Select "Insert" a "chart" a "column chart."
2, in the functional area Select "Insert" a "shape" a "rectangle", in the table area to draw a rectangle.
3. Right-click the rectangle, choose Format shape, on the Fill tab, select Solid color, and the transparency adjusts to 50% to determine
4, CTRL + C copy Rectangle, select the column in the chart, Ctrl + V paste directly.
5, add data labels, beautify the chart, the final effect as shown
Note: Because graphics have a richer set of effects, this is done using the method of inserting graphics.