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..
Last edited by ABBOV; 03-27-2021 at 10:42 AM.
Reason: wasn't ready yet..
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.
Originally Posted by shg
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By pigy33 in forum Excel General
Last Post: 02-02-2015, 01:24 PM
By roobanr in forum Excel Charting & Pivots
Last Post: 04-30-2014, 05:57 AM
By pric9331 in forum Excel Charting & Pivots
Last Post: 05-22-2013, 07:31 PM
By technopersia in forum Excel General
Last Post: 12-10-2012, 11:15 AM
By TSM in forum Excel Charting & Pivots
Last Post: 07-02-2012, 07:58 AM
By bat069 in forum Excel General
Last Post: 04-22-2010, 10:38 PM
By harshdesai in forum Excel General
Last Post: 03-23-2010, 07:40 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1