+ Reply to Thread
Results 1 to 2 of 2

Plotting one dataset on one y-axis and two x-axes

  1. #1
    Registered User
    Join Date
    08-06-2017
    Location
    Reykjavik, Iceland
    MS-Off Ver
    2016
    Posts
    1

    Question Plotting one dataset on one y-axis and two x-axes

    Hi all,

    Trying to get some data together for my thesis and attempting to make it a bit more organized... is there any way to plot the same dataset with two x-axes instead of having to make a separate series on a secondary axis? I feel like logically it might not work, but figured I'd ask the experts.

    Attaching a photo so you know a bit more about what I'm asking.

    example.png

    Thanks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Plotting one dataset on one y-axis and two x-axes

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



+ 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. x-y plotting in excel with two y-axes
    By PackYak in forum Excel General
    Replies: 2
    Last Post: 11-18-2015, 05:37 PM
  2. Plotting X and Y Axes
    By john_ in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-25-2014, 05:08 AM
  3. Plotting multiple series as a single dataset
    By kevinjay1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2012, 07:10 PM
  4. Plotting two axes on a scatter graph
    By Climaxgp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-06-2010, 07:27 AM
  5. Plotting 2 different graphs on 1 set of axes
    By Christian411 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-19-2009, 07:39 AM
  6. Plotting on 2 vertical axes on the same plot
    By ady_mech in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-19-2008, 08:45 AM
  7. Plotting on Line column on 2 axes
    By Dharmesh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-25-2007, 05:43 AM

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