+ Reply to Thread
Results 1 to 2 of 2

Creating a combination chart (Bar with Scatter Points)

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    New York, New York
    MS-Off Ver
    2010
    Posts
    5

    Creating a combination chart (Bar with Scatter Points)

    I've been having issues how to set up a combination of a bar chart and a combination chart. The way I currently have it laid out is that it shows the start and end date of an item (shown in Columns B and C) as a bar chart. I want to add scatter points to plot on the same chart of the "actual completion date" (shown in column D). For whatever reason, I've tried to set the data in column D as a scatter chart and secondary data, but it screws up the whole thing. I'm not entirely sure if my process is incorrect or why exactly it's not showing up how I'd like it to.
    Attached Files Attached Files

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

    Re: Creating a combination chart (Bar with Scatter Points)

    Difficult to say what is going wrong. After changing the 3rd series to an XY scatter chart, I would expect that you will need to go in and change the Y values and X values ranges to the appropriate X and Y values that will give the desired look. After changing the series chart type to XY scatter, what are you using for the X and Y values of this series?

    I also note that your secondary vertical axis is set to automatic min and max. I find that I usually need to fix these values to appropriate values in order to get the XY series to show up in the right place. For a bar chart with 33 categories (if I counted correctly), this usually needs to be 0 to 33 or similar.

    This should be helpful: http://peltiertech.com/Excel/Charts/BarLineCombo.html
    Last edited by MrShorty; 05-02-2017 at 04:11 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Attach Labels to Points on Scatter Chart
    By ryanpetersen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2014, 05:33 AM
  2. [SOLVED] overlapped points in X-Y scatter chart
    By mahmoodn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-03-2013, 06:53 AM
  3. [SOLVED] labeling data points on a scatter chart
    By Mr Tee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2006, 08:20 AM
  4. Combination stock and scatter chart
    By ArtZ in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-08-2006, 04:10 PM
  5. Scatter chart with columns instead of points
    By Bill_S in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2005, 12:05 AM
  6. Combination chart? Stacked cylinders and scatter
    By sdubose99 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-26-2005, 11:26 PM
  7. Data Points in Scatter Chart
    By CWILSON in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-26-2005, 10:07 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