+ Reply to Thread
Results 1 to 4 of 4

Quarterly X axis line graph

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    na
    MS-Off Ver
    2010
    Posts
    24

    Quarterly X axis line graph

    Hi All

    I have a data dump with 2 columns. Column A shows daily dates going back 5 years, Column B shows the price. In excel 2010 when i chart this it defaults to a bi montly view on the x axis. However I would like something like this https://alesandrab.files.wordpress.c...onal-chart.png where i can show the quarter and also year, looks alot cleaner.

    How do i go about doing this? Do i need to create additional columns in the excel sheet showing quarter and year? Or can the excel chart do this for me automatically.

    Thanks!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Quarterly X axis line graph

    Take a look at this Pivot Chart and see if it looks like something you want explore.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    11-25-2015
    Location
    na
    MS-Off Ver
    2010
    Posts
    24

    Re: Quarterly X axis line graph

    Thanks, this could work, could i remove the filters on the graph so that i can paste it into a powerpoint and keep it looking clean?

    Also how did you get the x axis like that because i cant seem to replicate it, could you give me a step by step?

    Thanks
    Last edited by AK123; 02-24-2017 at 07:22 AM.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Quarterly X axis line graph

    Yes, the field buttons can be hidden. PivotChart Tools > Analyze > Field Buttons > Hide All
    Steps:
    1) Select any cell in the data and press Ctrl + T to make it a table,
    2) Insert a Pivot Table, Book 10 uses the same sheet, but also could be on a new sheet,
    3) Date to Row Labels,
    4) Select any date and right click
    5) Select Group > Quarters and Years > deselect Months,
    6) Price to values (Value Field Settings > Average > Number Format > Currency),
    7) PivotTables Tools > Options > PivotChart (X axis should be formatted by quarter and year when chart appears).
    Let us know if you have any questions.
    Attached Files Attached Files

+ 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. *Help* Line of best fit across multiple Y axis line graph
    By zeroX14 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2015, 11:31 PM
  2. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  3. Creating a third axis within a line graph
    By NeoFlex in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-30-2012, 08:03 PM
  4. Quarterly Data Charted to Standard Line Graph
    By RileyBear in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-08-2008, 11:02 AM
  5. line graph XY axis cant do
    By jagguy in forum Excel General
    Replies: 1
    Last Post: 07-23-2008, 07:29 AM
  6. 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
  7. [SOLVED] Second x-axis for line graph
    By Sabine in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-17-2005, 09:05 PM

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