+ Reply to Thread
Results 1 to 2 of 2

Graphing Secondary Axis- Incorrect date (4/19/2019) alignment

  1. #1
    Registered User
    Join Date
    10-11-2019
    Location
    MT, United States
    MS-Off Ver
    Excel
    Posts
    1

    Question Graphing Secondary Axis- Incorrect date (4/19/2019) alignment

    Hello,
    I have 4 sets of data which I want to graph showing dates and data. I am graphing 2 data sets on scattered lines and 2 data sets on clustered columns. When I plot the primary axis scattered lines, excel asks for both X & Y (date and data). When I plot the secondary cluster columns, excel asks for only Y data (data) and the data is assumed from editing the horizontal category Axis.

    My problem is that the data does not line up properly . The data overlaps in inconsistent dates. For example, where the column and line plot intersect are on 4/19/2019 and 5/5/2019, when I want them to interest on the same day. I believe the columns are mixed up and do not align with the dates on the X-axis. How do I fix this?

    For example.
    my line data is discharge in gpm
    9/27/2019 8:00 25
    9/27/2019 10:00 23
    9/27/2019 12:00 22
    9/27/2019 14:00 23
    9/27/2019 16:00 23
    9/27/2019 18:00 25
    9/27/2019 20:00 23
    9/27/2019 22:00 34
    9/28/2019 0:00 30

    My column data is rain data in nches
    9/25/19 0:00 0.01
    9/26/19 0:00 0.10
    9/27/19 0:00 1.0
    9/28/19 0:00 1.5



    Thank you,
    Betty Walter
    Last edited by bjwalter6329; 10-11-2019 at 12:46 PM.

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

    Re: Graphing Secondary Axis- Incorrect date (4/19/2019) alignment

    Not sure how much we can help with only your description to go on. We will need to know exactly how each data series is defined, exactly how you have the horizontal axes formatted, and probably some other things that don't come immediately to mind. The easiest way would be to create a sample file (dummy data, if needed) that illustrates the problems, an explanation of what is wrong, and an explanation of what you want to see differently in the chart. We can then see exactly what you are currently trying and suggest specific changes that will (hopefully) yield the desired result.
    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. Alignment of labels for secondary axis
    By Alexander Willey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-22-2018, 05:18 AM
  2. date on x axis of scatter chart is incorrect
    By whburling in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-19-2017, 07:41 AM
  3. [SOLVED] Secondary Horizontal date axis
    By TimlmiT in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 09-19-2016, 12:11 PM
  4. [SOLVED] Alignment of Secondary X-Axis in Excel 2010
    By Krandamor in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2013, 02:49 PM
  5. Alignment of secondary X Axis
    By Huddle in forum Excel General
    Replies: 4
    Last Post: 02-23-2011, 12:20 PM
  6. Excel 2007 : Secondary axis alignment
    By primozek in forum Excel General
    Replies: 9
    Last Post: 01-13-2010, 07:45 AM
  7. Graphing: Adding a secondary axis
    By bluerog in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-21-2009, 02:24 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