+ Reply to Thread
Results 1 to 2 of 2

Adding multiple vertical axis labels for different units on the same graph.

  1. #1
    Registered User
    Join Date
    06-12-2020
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    6

    Question Adding multiple vertical axis labels for different units on the same graph.

    Good afternoon,

    I am creating a simple excel sheet to track my body as I undertake a new gym regime. I would like all of the information on one graph however resting heart rate and weight come under different units to the measurements. Is it possible to have multiple axis on the same graph?

    Thank you for taking the time to look I have attached a sample sheet with some rough expected values.

    Warm wishes

    Dexter
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Adding multiple vertical axis labels for different units on the same graph.

    You already have two axis' set up on your example.
    There data shows three different types (kg, bpm, cm) so one of these can't be plotted unless you share an axis.

    "10-20" as a value won't be shown on the chart, you need to enter actual values eg. 15


    Select the chart and from Chart Design on the ribbon you can select Change Chart Type to choose which series goes on which axis.
    Or Select Data to remove any series that you want to omit (your third data type)
    Say thanks, click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-06-2019, 07:30 AM
  2. Replies: 1
    Last Post: 09-19-2017, 12:55 PM
  3. Multiple Labels under X axis for Bar Graph
    By maxhecht2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-12-2017, 03:09 AM
  4. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  5. [SOLVED] Adding Multiple Level X-Axis labels
    By cartica in forum Excel Charting & Pivots
    Replies: 25
    Last Post: 07-17-2014, 11:30 AM
  6. Replies: 2
    Last Post: 05-16-2010, 11:23 PM
  7. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1