
Switching Primary and Secondary Axis | MrExcel Message Board
Oct 31, 2014 · You could switch all series to the primary axis, then switch the ones that had been primary to secondary. This may affect the charts' appearance, as in general, primary axis …
How do you swap table axes? | MrExcel Message Board
Aug 29, 2002 · Is it possible to swap the axis of a table SO that the columns become the rows and vice versa? I tried using the pivot table function, but it gives total sums and other stuff that i …
switch order of double y axes (left-right)? - MrExcel
Mar 19, 2004 · In a scatterplot graph, I have two y axes, and want to display what is now the right y axis as the left one (as it has more importance to the display), and what is now the left y as …
Creating a Pivot Chart without changing the table - MrExcel
Feb 5, 2016 · However at the moment, when I create the charts, excel makes a Pivot Chart, which shows all of the data in that pivot table, rather than the specific data which I wish to show. …
Swapping Double Y axis Excel Help | MrExcel Message Board
Dec 2, 2010 · Hi there, I have a bunch of charts that have double Y axis (one on the right, one on the left). I would like to switch them around so the right Y axis is on the left and vice versa. I …
Changing a bar to a line in a combo chart - MrExcel
Jan 13, 2002 · I have a combination chart that I am ploting six columns of data. Excel automatically plots 3 on one axis (bars) and 3 columns on the secondary (lines). However, I …
VBA Chart Switch Row/Column Help | MrExcel Message Board
Aug 13, 2008 · Is there a way in VBA to do the equivalent of pushing the 'Switch Row/Column' button seen in the Excel 2007 chart wizard when selecting the data range for a chart? …
Dynamic Y-Axis On Charts | MrExcel Message Board
Jul 22, 2016 · The "Auto" option on the axis options page doesn't work very well, as it always sets the minimum of my bar charts to "0". This renders the charts useless if, for example, the data …
Macro to change all x- and y-axis in every chart in a ... - MrExcel
Dec 27, 2014 · Hi, I have a worksheet that has several graphs and I've set up a a worksheet_change function to change x and y axis values according to user input. What I …
How to easily switch x and y axis in Excel for Mac 2011
Oct 11, 2013 · All, please can you help? I've just moved to using excel for mac 2011, and I am working with charts. When I build a chart excel for mac seems to default to having the largest …