+ Reply to Thread
Results 1 to 2 of 2

Scatter to Decimal with Combined Column Schart

  1. #1
    Registered User
    Join Date
    05-27-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    1

    Scatter to Decimal with Combined Column Schart

    Hi,

    I have a combined column & scatter chart. The only problem is, I can't get the scatter dots to go into the decimal point positition to align with the columns:
    chart.PNG

    I've tried formatting the X axis - for some reason I have to select Date for these graphs to combine, even if the values are numbers. If I choose Automatically Select then the 2 graphs are separated completely. I've set the Category to Number and to 2 decimal places.

    Thanks so much,

    Veronica
    Attached Images Attached Images

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

    Re: Scatter to Decimal with Combined Column Schart

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Column charts are normally equally spaced on the horizontal axis. If you use date axis then you can alter the spacing but only down to the nearest day.
    In order to get the xy series to align you need to determine what the x position of each column is.
    Cheers
    Andy
    www.andypope.info

+ 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: 13
    Last Post: 10-15-2018, 05:39 AM
  2. Fraction is read as decimal when text is combined in new cell
    By robclark63 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2017, 11:24 PM
  3. [SOLVED] Scatter Blotter with two sets of Data and combined X axis
    By Nituz in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-02-2016, 06:36 AM
  4. [SOLVED] Display only 1 decimal place but when combined with text
    By Leonthefixer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2015, 06:58 AM
  5. Stacked column combined with xy scatter plot.
    By S K ROY in forum Excel Charting & Pivots
    Replies: 41
    Last Post: 03-18-2012, 04:09 AM
  6. Create a Combined Chart for Stacked Area and Scatter
    By PosseJohn in forum Excel General
    Replies: 2
    Last Post: 11-29-2010, 12:53 PM
  7. combined scatter plot and line data
    By bmayers in forum Excel General
    Replies: 2
    Last Post: 06-25-2006, 01:15 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