正在加载视频...

视频加载失败

Create a Combo Chart in Excel 🧵

16,451 次观看 • 1 年前 •via X (Twitter)

4 条评论

CheatSheets 的头像
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’.

CheatSheets 的头像
CheatSheets1 年前

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

CheatSheets 的头像
CheatSheets1 年前

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

CheatSheets 的头像
CheatSheets1 年前

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

相关视频