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
  • แนวปฏิบัติและการใช้ชีวิต

ความคิดเห็น • 5

  • @dildimekro8329
    @dildimekro8329 6 วันที่ผ่านมา

    Thank you 🙏🏻
    It was very clear and good explanation

  • @nadermounir8228
    @nadermounir8228 3 หลายเดือนก่อน

    This is a very important graph that I need for work. Thank you very much

  • @richardgordon
    @richardgordon 3 หลายเดือนก่อน

    Amazing video! I learned a whole lot of useful things from this video. Thanks!

  • @RanaSheharyar87
    @RanaSheharyar87 3 หลายเดือนก่อน

    Thanks👍

  • @nemrabboud4636
    @nemrabboud4636 หลายเดือนก่อน

    Hi, I have a table with 3 teachers grading 4 students in 4 subjects. what type of chart is the best? Thanks!