Results 1 to 12 of 12
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Multiple X-Axis labels! (Excel 2002)

    Hi all,

    Is there any chance that the attached chart can contain multiple X-axix labels.

    The blue cells contain measurements taken on the date in the red cells. The measurements are taken on the same "day" over 4 years, but the day does not necessarily mean the same date. So for accuracy sake in reading the chart, it is NB that the date also occur on the X-Axis for each year!

    I have created a chart that is plotting the first 2 years, but I cannot show the second years dates on the X-Axis. I was under the impression that I may need a XY Scatter chart....but this also did not work!

    Any ideas for the guru's!

    PS: Ideally there should be a offset od a day or 2 for each point taken over the next year. IE, 2002 reading was 2101 (date), and at the same time in 2003 it was 2001 (date), so the chart must not plot the point on the same intersection, but slightly offsetted!!

    Hope I'm clear!

    Any help/advice would be greatly appreciated!
    Cheers
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple X-Axis labels! (Excel 2002)

    See the attached. I first specified that the 2003 series was to be plotted on the secondary y axis, then went into Chart Options and turned on secondary x axis and turned off secondary y axis. Next, I went into Source Data and specified the source range for the secondary axis.
    I added two blank dummy series, one for the primary axis and one for the secondary axis, and changed the series order to make the 2002 and 2003 series appear next to each other instead of overlapping.
    I deleted the legend entries for the two dummy series.

    BTW, Pinotage?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple X-Axis labels! (Excel 2002)

    Thanx for the reply Hans. I appreciate it!

    Your method limits me to only two years? I am unable to add a 3rd and 4th x-axis!

    I did an x-tensive search and found a <post#=266927>post 266927</post#> by Steve that mentions to concatenate the x-axis values. This I did, and it is closer to what I need. See the attachment. Is there any way to modify the data table so that the x axis labels appear in the table to read easier? It would look more presentable to have the legend key next to each date!!

    PS: I'm probably asking the impossible here!!

    Any ideas or further tweaks on this?
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple X-Axis labels! (Excel 2002)

    You can only have a primary axis and a secondary axis, not a 3rd, 4th one etc. (Where would Excel put them?)

    You can concatenate the category labels with CHAR(10) (line feed) instead of " ", for example in A4:

    =B4&CHAR(10)&D4&CHAR(10)&F4&CHAR(10)&H4

    and fill down to A12. You'll see boxes in A4:A12 unless you format them to wrap text; in the chart each date will be on a separate line. I don't think it's possible to have the category labels appear in the data table below the chart. But perhaps Steve has a brilliant idea.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple X-Axis labels! (Excel 2002)

    BTW - Pinotage? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple X-Axis labels! (Excel 2002)

    The data in your spreadsheet could well refer to the ripening of wine grapes (sugar content and color), so I mentioned South Africa's "own" wine grape. It wasn't meant seriously.

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple X-Axis labels! (Excel 2002)

    I knew you were not serious, but obviously your wine knowledge is more than mine. I know of Pinotage wines, but couldn't relate it to what you meant in the post?

    BTW: When I use Char(10) the x-axis labels do not go below each other? What am I missing here?
    Regards,
    Rudi

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multiple X-Axis labels! (Excel 2002)

    Change the alignment format of the axis to 0, not automatic

    Steve

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple X-Axis labels! (Excel 2002)

    Anthocyanins are the purplish pigments in the skins of dark grapes. Just like white grapes, dark grapes start out greenish. As they start to ripen, the skins become darker because anthocyanins are formed.

    In the previous chart, you had a data table. That causes the Char(10)'s to be displayed as line feeds. In the current one, you don't have a data table.

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multiple X-Axis labels! (Excel 2002)

    How about an XY chart?

    I think this is cleaner and more clear... (the x-dates are all the same "day" but in 2000 to put them on the same "scale")

    Steve

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple X-Axis labels! (Excel 2002)

    Thanx Steve, that did it!

    Thanx Hans for all your input and time!

    Cheers
    Regards,
    Rudi

  12. #12
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple X-Axis labels! (Excel 2002)

    Steve,

    Your scatter chart is perfect. This is spot on what I was after...as it plots the small variance between the days too!

    Cheers and many thanx too!
    Regards,
    Rudi

Posting Permissions

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