Swap axes on a scatter graph
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.
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.
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.)?
How do I label data points in an XY Scatter plot?
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 ?
Related Applications & Scripts
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.
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.
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).
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 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!