How to Make a 3 Axis Chart in Excel

Поделиться
HTML-код
  • Опубликовано: 30 июн 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
  • ХоббиХобби

Комментарии • 4

  • @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!