Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Can anyone help me with this Excel conundrum?

  • 04-03-2005 4:20pm
    #1
    Basq
    Registered Users, Registered Users 2 Posts: 44,413 ✭✭✭✭


    Hello all,

    How exactly do you do a three axis chart in Excel? Looked it up online and can't find much information on making the third axis.. just information on making a third line for a scatter chart.

    This is the chart i was to put into Excel:

    image35.gif

    Notice the axis for lactate, speed and heart.

    Any suggestions / advice on how to implement this into Excel is much appreciated.

    Many thanks in advance.


Comments

  • #2
    seamus
    Registered Users, Registered Users 2 Posts: 68,190 ✭✭✭✭seamus


    Insert -> Chart -> Custom Types -> Lines on 2 Axes.

    Easy peasy.


  • #3
    Basq
    Registered Users, Registered Users 2 Posts: 44,413 ✭✭✭✭Basq


    seamus wrote:
    Insert -> Chart -> Custom Types -> Lines on 2 Axes.

    Easy peasy.

    Cheers for that Seamus.

    Am having hassle getting it to recognise / label the third (right) axis still though!


  • #4
    seamus
    Registered Users, Registered Users 2 Posts: 68,190 ✭✭✭✭seamus


    basquille wrote:
    Cheers for that Seamus.

    Am having hassle getting it to recognise / label the third (right) axis still though!

    Right-click on the white area of the chart and stick in the labels for Y axis and Secondary Y axis. :)

    Send me on the data if you want, I'll sort if for you.


  • #5
    Basq
    Registered Users, Registered Users 2 Posts: 44,413 ✭✭✭✭Basq


    seamus wrote:
    Right-click on the white area of the chart and stick in the labels for Y axis and Secondary Y axis. :)

    Maybe my use of the word 'labelling' was a little inaccurate!

    Recognise was more appropriate.

    I was in source data but all i can find in there is a way to label the secondary x-axis (see attachment) but it's the secondary y-axis i want labelled.

    Maybe i'll take you up on your offer of sorting the data. I want the data from the third grid from the left to be in the secondary y-axis.

    Here it is.

    Much appreciated, seamus.


Advertisement