Switch x and y axes
I have a chart that has two Y-axes, the primary on the left and the secondary on the right. Is there a way to flip these axes without recreating the chart? In other words, get the secondary axis to be on the left and the primary on the right?
I would like the categorical info to be displayed vertically and the value axis to be displayed horizontally. Is there any way around it?
Using Excel 2007, everytime I refresh pivot table data, my charts lose almost
all of the formatting (ex. axis will disappear and chart type will revert from lines to columns).
Most annoying problem I have when this happens is the primary Y axis moves from the left side to the right side of the chart, and when I re-introduce the secondary Y axis, it will appear on the left. How can I easily move the primary Y axis back to the left side of the chart or switch the two axes?
I've tried choosing Layout - Axes to hide and re-display the axes but this
I have created a chart in Excel using a pivot table. The chart I am using is 2 axes, bar and line and I am using 3 sets of data. One of which I want as a
bar and the other 2 as lines. It defaults to the other way around ie 2 bars and one line. The data I wish to switch to a line is so small that I can't click on it and change to secondary xix. is there another way to do it?
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.
Related Applications & Scripts
Click these light switches to toggle them from on to off. This animation is at 30fps. The code is setup so you can easily attach your custom functions within each button press, whether youre turning the switch on or off. Use this to control lights, or sounds, etc. Anything that has a Boolean value can perfectly be controlled by these switches.
Switch form is a simple animated form with three very common forms. The user can change form without loading a new page. You only need to alter few CSS rules to completely change their appearance and perfectly match them to your website.
- Customize through CSS
- Easy implementation
- Browser Compatibility: FF 3 .6+, IE7 , IE8, Chrome, Safari 5 and Opera.
One of the most versatile scripts of its kind, we created this one to compact arbitrary content on your page so they're expandable on demand. This allows you to save space within your webpage and even add to the aesthetics of the webpage's design in many cases. What sets this script apart from most other you'll find are the following features:
- Supports multiple "groups" of switch contents on the same page, each with their own independent settings.
- Decide whether to collapse previous content when expanding the current, so only one content can be open at any time.
- Specify arbitrary HTML to prefix the headers to indicate open and closed states, such as an open and closed bullet image.
- Ability for certain headers to get its contents remotely from an external file on the server via Ajax, fetched only when header is expanded.
- Set the color of the headers when its content is open or closed, respectively.
- Supports persistence of content states using session or non-session cookies, so navigating away from the page and revisiting it won't reset their states.
- Specify which contents (if any) should be expanded by default. Note that cookie feature if enabled overrides this setting.
THIS IS AN "XML" DRIVEN AUTO SCROLLING TEXT EFFECT Especially For Your Banners. XML File is very easy to update, simply write your text to XML file and let it scroll.
You will need flash cs4 or higher only if you want to change the background. Here are the values you can change through XML , without opening Flash:
You have four options for alignment of your text: "left", "right", "center", & "justify".
You can easily adjust whole textFields "textColor", "textSize", and "textFieldWidth" values.
You can set textFields "textScrollDuration" to fine tune your scrolling animations duration.
The speed of "Fade-out" effect of your text, and the speed of textScrolling is also adjustable through XML .
RotationX (3D x-axes angle) value of the textField is alterable with ease.
Of course, you can have a link too.Just write it down to XML File, Or you can simply switch it off.
And finally you can use "CDATA" tags to format text severally with some basic HTML properties.
A very descriptive help file included.
The Site Switcher is modular application with three components; switcher, assign and dashboard. Any of the three plug-ins can be used on their own, or together. The application lets you create an inter-domain or cross-domain website switcher to easily navigate between different URLs. It can be useful for corporate or other websites where such kind of functionality is required. It can also be quite handy for things like presentations, top-frames, navigation, online documentation etc.