You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Swap axes on a scatter graph

Swap axes on a scatter graph

Price: FREE

Anybody know of an easy method of swapping the x and y axes over on a scatter graph. ie so that the data graphed as the y-axis data becomes the x-axis and vice versa. I have data for two values of Q and one of P in a supply and demand diagram. The Q comes out on the vertical axis whereas an economist requires P on the vertical axis and Q on the horizontal. There are two lines that cross at equilibrium

Visit publisher's web-site: Swap axes on a scatter graph

Category and Tags: ExcelTutorials : : Charts

Related Tutorials

Swap the X and Y axes

Free: Yes
Tags: Excel › Charts

I have a line chart on which I need the categories to appear on the vertical axis and the data to appear on the horizontal axis - how can I swap them? I tried swapping the source data in the dialog box but that doesn't seem to work, unless I am doing something wrong.

How do I swap X & Y Axes on a Chart

Free: Yes
Tags: Excel › Charts

A colleague has created a chart but needs to swap the X & Y axes. I know
this isn't as easy as it sounds, as I've been reading through lots of entries in this forum. I have found Jon Peltier's fantastic little .zip file (SwitchXYAxes.xls) however, when I try and run the "Active Chart - Switch X
Y Axes" option I get a run time error "1004 unable to gt the
MinimumScaleISAuto property of the Axis class". I'm now stuck as I know next
to nothing about VBA.
I would be really, really grateful if someone could come back with either an answer to swapping axes, or to get Jon's little macro running.

Scatter Plot and Axes labels

Free: Yes
Tags: Excel › Charts

if I have my data as Sl. Production Quality
and want to know who is in the high Production/High Quality, High Production/Low Quality etc. the 4 areas, I can use the xy scatter plot.
but the points which represent these data cannot be labeled. How do I know which point on the graph corresponds to which person (Sl. No.)?
OR
How do I label data points in an XY Scatter plot?

Scatter Graph

Free: Yes
Tags: Excel ›

Struggling with an excel scatter graph for a project. The thing is that the x-axis has to be non-linear.
i.e the x axis reads 1 2 3 4 5 1 When I link to the source its is displaying two points on the graph one above the other. How do I fix this and get them in the order I want ?

Column-Column on 2 axes

Free: Yes
Tags: Excel › Charts

I am using Excel 2003. I see how I can create a Line-Column Graph on 2 Axes.
However, can a column-column graph be created on 2 axes?
I am trying to mimic this graph style which I saw in another presentation.

Related Applications & Scripts

phpServer: Kernel, memory, swap, hd space info

Free: Yes
Tags: PHP › Excel User Information

phpServer (based on phpSystem) is a php script designed to give the user information about their system in an easy to read format, from any internet connected computer, such as kernel, uptime, memory and swap and partition space. Additional network-centr.

Chart Animation Script

Free: Yes
Tags: JavaScript › Excel Charts

Animated Chart script generator allows you to create a bar graph table of the data given to it. This is a graph and chart animated javascript which can be incorparated into any webpages. Just input the data of the involved elements, the animated script will chart out an XY Graph.
a) The Chart animation generator is compatible with all main browsers.
b) This script will dymanically draw the graph from the given values.
c) It automatically scales the axes.
d) Bar colors, fonts, chart colors, can be easily customised.

JavaScript Multimedia Rollovers

Free: Yes

Make your image rollovers much more dynamic by using the Microsoft Transition Filters built into Internet Explorer on the Windows platform. Using this script, visitors with I.E. 4+ will see a very dynamic-animated image rollover. In all other browsers the script degrades to a simple image swap. The low bandwidth of an image swap with the high impact of a Flash animation (without using Flash).

Last.FM API: Scatter polaroid style images

Free: No
Tags: JavaScript › Excel Image Effects

Scatter polaroid-style images of all artists in a users library, with playcounts and tagcounts, across your desktop. These images are obtained by implementing Last.fm Web Services, specifically library.getArtists. Feel free however, to use any one of the other API Methods available and expand upon this.

AutoGRAPH Bar Graph Generator

Free: No
Tags: Flash › Excel Charts

AutoGraph allows you to easily customize and set up graphs in seconds. All you need to set up your own bar graph is to resize the background box to your dimensions, and set how many bars as well as what information it needs to show. You can easily change margins, sizes, colors, text colors etc without diggin through the library or code.
Its perfect if you deal with bars or charts to display data for corporate clients. It cant get easier than this!

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing