+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Secondary x axis with Quarter values

  1. #1
    Registered User
    Join Date
    12-01-2008
    Location
    istanbul
    Posts
    8

    Question Secondary x axis with Quarter values

    Hi helpers!

    I have a 8 year daily Copper data and I need to show it in 2 x axis labels.
    -Primary x axis: displays Months (J, F, M, A..etc)
    -secondary axis displays Quarter-Year (Q1 05, Q2 05...., Q1 06..)

    ActualIy some one has created it this chart but I don t have it in excel but only in JPG format. Here I attach it. How can I need to create the same look in exel 2007? Can anyone help me please?

    thanks

    amy
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-12-2011
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Secondary x axis with Quarter values

    Amy
    If this is what you need then its simple to make.
    Highlight A1:C12 in example and select insert line chart
    Bruce
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-01-2008
    Location
    istanbul
    Posts
    8

    Re: Secondary x axis with Quarter values

    thanks for answer. well, yes I wanted to create a such graph but with daily data. I mean I can t say the January value is 100 - There 21 working days in January 2005 and 21 data points for january.
    well, I couldn t get the reply from here but somehow I managed it by myself.
    If I enter Quarter info for every day and it collapses on each other.Excel picks the specific data points and I found out every 69th data is the refer point to create quarterly label. So if i only put Quarter info on every 69th data, it works OK..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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