How to remove irrelevant months from the X axis in a bar chart?
Results 1 to 7 of 7

Thread: How to remove irrelevant months from the X axis in a bar chart?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to remove irrelevant months from the X axis in a bar chart?

    Hi all

    I'm an absolute excel newbie, so please forgive me for my lack of knowledge...

    I have values for 2018 (Jan, Feb and March) and 2019 (Jan, Feb and March). I've created a bar chart but it is displaying Months between March 2018 and 2019 which I don't want. What I'd ideally like is to have Jan 2018 and Jan 2019 side by side, and then the same for Feb and March... so I can easily see a trend. How would I go about creating a visualisation to represent these trends?

    Many thanks in advance

    S

  2. #2
    New Member
    Join Date
    Jul 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove irrelevant months from the X axis in a bar chart?

    Anyone?

  3. #3
    New Member
    Join Date
    Jun 2019
    Location
    Mississauga, ON, Canada
    Posts
    15
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove irrelevant months from the X axis in a bar chart?

    I think what would help is to put the 2018 and 2019 data into two different data series. That way the columns for each month can be beside each other like this.


    A good tutorial for the basics of Excel charting is by Excel MVP Leila Gharani at https://www.xelplus.com/charts-basics/

  4. #4
    New Member
    Join Date
    Jul 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove irrelevant months from the X axis in a bar chart?

    Thank you so much, Dave.

    Are you able to recommend a tutorial that will help me recognise when and how to remodel my data? Eg. My data is in tabular format with each row belonging to a record, and the date column is in dd-mm-yyyy format. Or would I be able to achieve this by using a pivot table?

    PS. I have thousands of records/rows.

  5. #5
    New Member
    Join Date
    Jun 2019
    Location
    Mississauga, ON, Canada
    Posts
    15
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove irrelevant months from the X axis in a bar chart?

    Unfortunately I am not an expert at data remodeling. If you want to explore pivot tables, which may be an option for what you are describing, Excel has a good basics tutorial available when you first open Excel. Instead of selecting a file, choose the tutorial on Pivot Tables and it will walk through what they are and you should be able to determine whether that will achieve what you want.

  6. #6
    New Member
    Join Date
    Jul 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove irrelevant months from the X axis in a bar chart?

    Quote Originally Posted by Dave Paradi View Post
    Unfortunately I am not an expert at data remodeling. If you want to explore pivot tables, which may be an option for what you are describing, Excel has a good basics tutorial available when you first open Excel. Instead of selecting a file, choose the tutorial on Pivot Tables and it will walk through what they are and you should be able to determine whether that will achieve what you want.
    Thank you so much

  7. #7
    New Member
    Join Date
    Jul 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove irrelevant months from the X axis in a bar chart?

    Sorry to bother you again. I'm just wondering if you're able to help me as to how to add an extra layer to this.

    What I'd like to do is break down the sale quantities by product. How should I structure my data in order to achieve this?

    At the moment, my data is structured in such a way so that there is a row for each transaction. Each product has multiple transactions. There is just one date column.

    Quote Originally Posted by Dave Paradi View Post
    I think what would help is to put the 2018 and 2019 data into two different data series. That way the columns for each month can be beside each other like this.


    A good tutorial for the basics of Excel charting is by Excel MVP Leila Gharani at https://www.xelplus.com/charts-basics/
    Last edited by sonic99; Jul 20th, 2019 at 10:23 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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