+ Reply to Thread
Results 1 to 2 of 2

Switch X and Y-axis to create a 'location - time graph'

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2016

    Switch X and Y-axis to create a 'location - time graph'

    I am trying to create a 'distance- time' graph but instead of a distance i have got location names.
    With a pivot chart I am able to get things visible but the x-and y- axis need to switch.

    Any idea on how to switch the axis on a pivot chart? See the included sample.

    Thanks in Advance for your thoughts..

    Attached Files Attached Files
    Last edited by ABBOV; 03-27-2021 at 10:42 AM. Reason: wasn't ready yet..

  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Switch X and Y-axis to create a 'location - time graph'

    I'm not sure I fully understand, but this may not be doable using a pivot chart. I don't think that, even in the newest versions, Excel has a built in "line chart with a vertical category axis and horizontal value axis" chart type.

    Since pivot charts tend to be restricted to "easy" built in charts, this probably cannot be created using a pivot chart. This tutorial talks about the pros and cons of pivot charts and explains how to make a "regular" chart from pivot data for those cases where we need the full flexibility offered by a regular chart (like building a "dot plot" like you seem to be describing). https://peltiertech.com/regular-char...-pivot-tables/

    If you can use a regular chart rather than a pivot chart, then you can use this tutorial to build a "dot plot" (with just lines and no markers) https://peltiertech.com/dot-plots-microsoft-excel/ This becomes a scatter + bar combination chart which is why a pivot chart cannot do this.

    If I understand what you want to do, you should be able to combine information from those two tutorials to build a regular XY + bar combination chart that will show your "Point" on the vertical axis and you times on the horizontal axis. Let us know if you have trouble understanding any steps and we'll help as best we can.
    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. Can't create axis on graph HELP!!!
    By pigy33 in forum Excel General
    Replies: 2
    Last Post: 02-02-2015, 01:24 PM
  2. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  3. [SOLVED] Pivot Chart Switch Row/Column Greyed Out--Need time on x-axis
    By pric9331 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-22-2013, 07:31 PM
  4. Replies: 1
    Last Post: 12-10-2012, 11:15 AM
  5. Need to create Stacked Graph with time as x -axis
    By TSM in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2012, 07:58 AM
  6. Replies: 2
    Last Post: 04-22-2010, 10:38 PM
  7. Create a graph having different X axis
    By harshdesai in forum Excel General
    Replies: 1
    Last Post: 03-23-2010, 07:40 AM

Tags for this Thread


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