+ Reply to Thread
Results 1 to 3 of 3

Combo chart with column and scatter

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    76

    Combo chart with column and scatter

    Hi all,

    I've spent the last hour trying to edit a combo chart I've put together for column and scatter.

    Everything looks fine with this chart until I change the data series marked as "Line Data" to work on a secondary axis. At that point all the markers for the data series disappear except for the first five - which are all in the correct place.

    For some reason, no matter how many times I do it, modify it or try to adjust it I can't get the remaining markers on the line graph to show up in the chart. There's probably a criteria that I'm not aware of for the X series in defining the data points for the scatter graph. But I can't figure it out.

    I've attached the spreadsheet. I'm just trying to get the series marked as Line Data to show up for all the values across the chart. At the moment it is only displaying the values for D6:D10.
    Attached Files Attached Files
    Last edited by Wizards; 02-11-2019 at 02:00 AM.

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

    Re: Combo chart with column and scatter

    I'm not sure why this should be the case, but I often find that I need to add the secondary horizontal axis in order to get these kind of combo charts to work. In your file I:

    1) Select chart -> Layout -> Axes -> Secondary horizontal axis -> show default axis. This displays the secondary horizontal axis at the top, and all of the scatter data points show up.
    2) Select the secondary horizontal axis and format to have fixed minimum at 0.5 and fixed maximum at 5.5, to match up with the values that correspond to the categories of the primary horizontal axis.

    That fixed it so that all of the "line data" points are on the chart and in the correct position. If desired, when everything is done and you are satisfied with the chart, you can format the secondary horizontal axis to be invisible (no line, no label, no tick mark).
    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
    08-30-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: Combo chart with column and scatter

    That works perfectly.

    Thanks for your help. Again.

+ 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