正在加载视频...
视频加载失败
Create a Combo Chart in Excel 🧵
16,451 次观看 • 1 年前 •via X (Twitter)
4 条评论

CheatSheets1 年前
Step 1. Click anywhere in the data. Go to the ‘Insert’ tab. Click ‘Insert Combo Chart’. And choose ‘Clustered Column - Line on Secondary Axis’.

CheatSheets1 年前
Step 2. Move the Combo Chart. Change the colors and style to fit your theme. Change the Chart Title.

CheatSheets1 年前
Step 3. Double-click the line, click the paint bucket icon, click ‘Marker’ and ‘Marker Options’, choose ‘Bult-in’ and select a circle.

CheatSheets1 年前
Step 4. Go to chart elements (click the ‘+’ symbol), expand ‘Data Labels’, and choose ‘Above’.
