+ Reply to Thread
Results 1 to 6 of 6

Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

  1. #1
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

    Lo All,

    Attached is a screenshot of a chart I built but am for some reason the latter part of the series seems to be off a little. The blue lined series "Total Leads" is the series in question. As you can see for Qtrs 1 & 2 the chart is inline but for 3 & 4 it has shifted over one. Any help on how to correct for this?

    ExcelComboGraphHelp.png

  2. #2
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Re: Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

    At further inspection, it seems they're all a little off. Hmmm...been playing with format options and can't get the sucker to line up...

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,897

    Re: Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

    Difficult to say much based on a picture. A sample file uploaded to the forum would be better (go advanced -> manage attachments -> upload attachment) I would guess that it has to do with the category x axis data for the two chart types not matching up. Try deleting the blank rows between the "blocks" in the line chart series.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

    You do not have enough data points in your line series in order to make the line data points align.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Re: Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

    Could had sworn I replied. This worked, Andy. Thank you good sir. Did the rep I originally added populate for ya?

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

    Re: Half of Combo Chart Series on 4-Axis Chart Shifting One Field Over

    Reps received, thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-07-2017, 03:17 PM
  2. [SOLVED] combo chart - how to make secondary axis (combo chart)
    By eeps24 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-20-2016, 02:38 PM
  3. Excel chart Y axis v's series
    By Rob K in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2015, 01:01 PM
  4. Replies: 2
    Last Post: 06-04-2015, 09:51 PM
  5. [SOLVED] Chart Combo - Splitting X axis
    By Grat in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-31-2012, 09:58 AM
  6. Chart w/x axis showing different series
    By JIBG in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-23-2007, 09:12 PM
  7. Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis
    By mw210461@yahoo.com in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2005, 05:05 PM

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