How to Make a 3 Axis Chart in Excel
ฝัง
- เผยแพร่เมื่อ 16 ก.ค. 2024
- Download the featured file here: www.bluepecantraining.com/wp-...
In this Microsoft Excel video tutorial I explain how to create a three-axis graph in Excel. Excel doesn't have a chart type for this but this video shows the workaround.
🕰️ Timestamps
00:00 Introduction
00:12 Create a chart
00:27 Duplicate the chart
00:34 Delete unwanted series in each chart
00:53 Create a secondary axis in the original chart
01:11 Change the colour of each vertical axis
02:28 Show tick marks on each vertical axis
02:59 Enter a chart title
03:26 Remove the background on the copy of the chart
03:55 Change the minimum value on the horizontal axis of the copy of the chart
04:49 Hide the horizontal axis in the copy of the chart
05:05 Remove gridlines in the copy of the chart
05:14 Overlay and align the charts
05:39 Adjust the legend
05:51 Remove the chart area borders
06:12 Add a rectangle behind the charts
06:46 Group the charts
#exceltips #exceltricks #exceltutorial #excelchart - แนวปฏิบัติและการใช้ชีวิต
Thank you 🙏🏻
It was very clear and good explanation
This is a very important graph that I need for work. Thank you very much
Amazing video! I learned a whole lot of useful things from this video. Thanks!
Thanks👍
Hi, I have a table with 3 teachers grading 4 students in 4 subjects. what type of chart is the best? Thanks!