+ Reply to Thread
Results 1 to 7 of 7

Value rather than category x-axis on combo chart

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Fremantle, Western Australia
    MS-Off Ver
    365
    Posts
    4

    Value rather than category x-axis on combo chart

    I have a combo chart with a scatter and a line, in which I would like to set minimum and maximum bounds for the x-axis in the same way I can for the y-axis. However, the combo chart insists on treating the x-axis as a "category" axis rather than a "value" axis, as it would in a line or bar chart. Consequently, the only options available for the x-axis are "text", "date" and "automatically select based on data", none of which give me what I want (which is simply to have markers on the x-axis for 0, 5, 10, 15, 20 and 25, which can very easily be done on a value axis). Is there any way around this?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,973

    Re: Value rather than category x-axis on combo chart

    Because scatter and line charts are so similar (really only differing in the nature of the horizontal axis), I wonder why you are making a combination line and scatter chart? I wonder because I think the specific solution probably depends on exactly why you need to combine both line and scatter charts together.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    07-12-2019
    Location
    Fremantle, Western Australia
    MS-Off Ver
    365
    Posts
    4

    Re: Value rather than category x-axis on combo chart

    The idea is for the line to be x = y, so it is clearly apparent which points have x > y and which vice-versa. My first approach was to just have a scatter plot and use a trendline to get the x = y line, but I'm not satisfied with this as the trendline appears on top of the scatter points rather than behind them. So alternative solutions to my problem might involve a) working out how to put a trendline in the background rather than the foreground, or b) any other means of having a diagonal line appear in a way that makes it look like one of the gridlines.
    Last edited by willbowe; 07-13-2019 at 02:07 AM.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,434

    Re: Value rather than category x-axis on combo chart

    Use a xyscatter chart and add a new series to draw the diaginal.
    That series only needs 2 sets of points to describe bottom left and top right.

    You will need to fix the axes min/max values if you want the line to go to the corners
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    07-12-2019
    Location
    Fremantle, Western Australia
    MS-Off Ver
    365
    Posts
    4

    Re: Value rather than category x-axis on combo chart

    But doesn't that just create two new scatter plot points? What I want is a line connecting the two, which is why I tried a combo chart. When I did this though, it wouldn't let me treat the x-axis as if it were for a scatter plot rather than a line graph (i.e. as a value rather than category axis).

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,434

    Re: Value rather than category x-axis on combo chart

    Yes, but you can format the series to not have markers and for the line to be formatted the same as the other gridlines.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-12-2019
    Location
    Fremantle, Western Australia
    MS-Off Ver
    365
    Posts
    4

    Re: Value rather than category x-axis on combo chart

    Yep - there's your answer. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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