How to Set X and Y Axis in Excel




About this tutorial:

Video duration: 39
In this video tutorial we will show you how to set x and y axis in excel.

In this video tutorial we will show you how to set x and y axis in excel.

Open the excel document you want to edit. Select the part of the text you want to edit. Go to “Insert” tab. Click on “Scatter” and select the preferred scatter.

After the diagram appears, right-click to it and choose “Select data”.

Select the column you want to change and click “Edit”. In next window you can set x and y values. After the changes have been done, press “ok” and see how the diagram changes.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

39 thoughts on “How to Set X and Y Axis in Excel

    Alpaslan Arabaci

    (December 25, 2018 - 3:14 pm)

    hello how can I write a formula for the standard deviation in a number array.

    JessemyBeadle

    (December 25, 2018 - 3:14 pm)

    Irritating 'wix' advert at start. Pop-ups cover the screen. New excel also does not seem to work with this video, I'm starting to believe microsoft are on a mission to make things as user unfriendly as possible.

    Darlyngtoo

    (December 25, 2018 - 3:14 pm)

    If you only have two options in the "Edit Series" part, try changing your graph to its original state first before changing the chart type. I set mine to scatter plot then I was able to see both the series X and series Y axis values

    phoenixbird

    (December 25, 2018 - 3:14 pm)

    What da hell in the most important part of the video you can't see anything because it's ful of ads.

    Alex S

    (December 25, 2018 - 3:14 pm)

    Excel is shit

    سمية Sumaia

    (December 25, 2018 - 3:14 pm)

    Thank you

    Abhishek Mitruka

    (December 25, 2018 - 3:14 pm)

    Useless Video

    Shawn Scholey

    (December 25, 2018 - 3:14 pm)

    I hope you die

    ritesh pratap singh

    (December 25, 2018 - 3:14 pm)

    useless really

    bboycrazyjames

    (December 25, 2018 - 3:14 pm)

    Ignore the BS here, all you need to do is change the graph type to "scatter graph" and you can plot the axis individually.

    Grape

    (December 25, 2018 - 3:14 pm)

    THANKS M8, iVE BEEN MAKING GRAPHS FOR YEARS AND I DIDNT EVEN KNOW THIS

    Man In Water

    (December 25, 2018 - 3:14 pm)

    Thanks for nothing

    LaoDecmius

    (December 25, 2018 - 3:14 pm)

    I only have two options in the "Edit Series" part. Can somebody please tell me why.

    Veritas B.

    (December 25, 2018 - 3:14 pm)

    perfect

    Ambi Sinistrous

    (December 25, 2018 - 3:14 pm)

    I was having a really hard time finding this information until I included desperate expletives in my search terms.

    Anant Sumaria

    (December 25, 2018 - 3:14 pm)

    wow excel 2003 is so much better than this crap wtf

    greysun9103

    (December 25, 2018 - 3:14 pm)

    Thank you so much! This showed exactly what I needed.

    Brian LeBlanc

    (December 25, 2018 - 3:14 pm)

    Thanks !….MS must be on drugs….not good 1's either

    badpanda84

    (December 25, 2018 - 3:14 pm)

    Grr  I knew how to do this all on Excel 2004 version.. why did they change this.. in the new version

    101tunes

    (December 25, 2018 - 3:14 pm)

    Why did they need to make something so simple so hard.

    Rick Bauer

    (December 25, 2018 - 3:14 pm)

    Totally useless. Nothing in this video is of any help. Save your time.

    NickWarnerMedia

    (December 25, 2018 - 3:14 pm)

    doesnt work for the new excel. there is a spot for y axis but no x axis… what are you thinking microsoft? why do you  make it so hard to make a simple graph?

    Dániel Szili

    (December 25, 2018 - 3:14 pm)

    fuck you, you fucking fuck.

    Joseph Watkins

    (December 25, 2018 - 3:14 pm)

    Thanks for sharing the info; Jesus Christ Bless you! 🙂

    HiddenLotus9

    (December 25, 2018 - 3:14 pm)

    Fucking Microsoft with their user unfriendly software…

    J B

    (December 25, 2018 - 3:14 pm)

    Thanks man 😀

    Madi Shay

    (December 25, 2018 - 3:14 pm)

    :') I did it

    Palma Nardozza

    (December 25, 2018 - 3:14 pm)

    THAT WAS EXTREMELY HELPFUL. I was about to pull entire chunks of hair from my head before seeing this. Thanks <3 

    chathura widanage

    (December 25, 2018 - 3:14 pm)

    I think you can do this simply by just selecting values ignoring the table heads. Not sure though. I am not an excel expert, just sharing what I found.. 🙂

    Kaleigh Schuler

    (December 25, 2018 - 3:14 pm)

    Fuck Excel, man. Why the hell do they have to make it so user unfriendly?

    buttonmash

    (December 25, 2018 - 3:14 pm)

    Seriously something as simple as this has to be so fucking hard.

    Angelo Zamudio

    (December 25, 2018 - 3:14 pm)

    Thank you sir!

    Dani Chen

    (December 25, 2018 - 3:14 pm)

    Why is Excel so difficult

    MegaRoseBunny

    (December 25, 2018 - 3:14 pm)

    Thanks!

    Jsablever

    (December 25, 2018 - 3:14 pm)

    Finally, a solution that works consistantly! Thanks for the pointer

    Andrew Uplifting trance

    (December 25, 2018 - 3:14 pm)

    hahhaaa

    Ben Blackshaw

    (December 25, 2018 - 3:14 pm)

    Thanks this helped ALOT!

    Cybrdivr

    (December 25, 2018 - 3:14 pm)

    Sorry i'm the asshole I didn't have my speakers turned up all the best.

    Cybrdivr

    (December 25, 2018 - 3:14 pm)

    Assshole there is no sound

Leave a Reply

Your email address will not be published. Required fields are marked *