+ Reply to Thread
Results 1 to 2 of 2

Column and Scatter/Smoothed Line Chart - X-axis values appear in wrong place

  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    Stoke-on-Trent
    MS-Off Ver
    Excel 2003
    Posts
    2

    Column and Scatter/Smoothed Line Chart - X-axis values appear in wrong place

    I am trying to build a Process Capability Tool (a quality improvement tool) showing a combined cumulative frequency column chart [this shows actual results from the process], a normal distribution scatter plot (smoothed line) [this shows the normal distribution of these results based on standard deviation and mean] and then show the Upper and Lower specification limits.

    I have managed to get the histogram and the normal distribution working but cant get them all to line up using the same x-axis values? Help!

    Development File_150315.xls

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Column and Scatter/Smoothed Line Chart - X-axis values appear in wrong place

    Select the axis. Right click, Format Axis --> Axis Options --> Make sure Date Axis is set for Axis Type. Will that work?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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: 2
    Last Post: 06-19-2012, 06:50 PM
  2. Wrong date on x-axis in line chart
    By sorent in forum Excel General
    Replies: 2
    Last Post: 12-26-2010, 05:39 PM
  3. Scatter Chart with Smoothed Lines
    By rachsull in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-31-2006, 02:25 PM
  4. [SOLVED] Area chart with smoothed line
    By Gail in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2005, 10:10 AM
  5. Time axis column and scatter/line graph
    By kraymond in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-08-2005, 08:06 PM

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