+ Reply to Thread
Results 1 to 4 of 4

Align primary and secondary x-axis in combination plot

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Align primary and secondary x-axis in combination plot

    Hello, in the excel sheet attached, I would like to line up both the secondary and primary x-axis plot in the combination plot. Currently, this is what I have:

    2020-05-22_16-04-24.png

    I would like the area plots to line up with the scatter plot. As shown above, the line plots are offset from the area plots. I want the lower x-axis to be the main axis that determines the min and max x-axis value.

    How to align the area plots to match up with the scatter plots? Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,115

    Re: Align primary and secondary x-axis in combination plot

    Any reason why you don't draw those columns with another xy-scatter series on the same axis.
    That way you can get variable widths.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    4

    Re: Align primary and secondary x-axis in combination plot

    Thanks for your response. I did not think of adding another xy-scatter series on the same axis. I sincerely appreciate your time and help.

    I wanted to show an area fill so that no data should appear in the "shaded region". I like your idea but wanted to get a shaded region for the limits. Thanks!
    Last edited by jimjones1958; 05-24-2020 at 02:02 AM.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,115

    Re: Align primary and secondary x-axis in combination plot

    I did not get the need for filled areas as your orignal file did not have a filled area chart.

    Change the Limit series to Area.
    Format the horizontal axis to be Date.
    Format fill colour
    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)

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