Microsoft Excel for Mac 2011 represents the largest step forward for serious Mac spreadsheet jockeys in many years, more so than either Excel 2004 ( ) or Excel 2008 ( ). There are literally. Rename the tabs: To rename, select a tab, like Home, Insert, Design in the Customize the Ribbon box, click > Rename. Add new tab or new group: To add new tab or new group, click below the Customize the Ribbon box, and select New tab or New group.

19 comments Let us say you have built a nice chart showing your sales and profits for the top 5 products (), with products on X axis. File compression mac. Suddenly your boss wants to switch the rows to columns (or transpose the chart) so that she can see metric level grouping instead of product level grouping. No need to freak out and rush to Espresso machine, You can do it very easily with Excel Charting features.

In today’s quick tip you will learn how to swap chart rows and columns in excel, In Excel 2007+, select the chart and go to “Design” tab. Here you will see a big-fat-“Switch rows and columns” button. Just click it and thump your chest. See this tutorial to understand. In Excel 2003, select the chart and in the chart toolbar, you see 2 little buttons, called as “by row” and “by column”.

Click the one you want and off you go. See this tutorial to get it. Read more and/or, be awesome at work. Chandoo, Nice writeup. I have been working with dynamic ranges for populating dynamic charts which works nicely for column charts (as no.

Of columns are fixed I can declare that many named ranges and assign them to series). But when it comes to row charts (each row is a series now), I am not able to find a way to define dynamic chart ranges. Is it possible to apply some sort of formula to make this 'switch rows to columns'? It would be great if it is achievable through formulas alone without any Macros and please share any info if you are aware of. Kobalt tool chest for sale. (I referred here - for dynamic column charts). You can also write small macro for the same.

Please find below the one which i write to randomly put columnr cell values in to rows cells. Sub CopyRandomCells() Dim stOrig As Worksheet Dim stName As Worksheet Dim lnCont As Long Dim i As Integer Dim j As Integer i = 1 j = 1 Application.ScreenUpdating = False lnCont = 0 idCont = 0 Set stOrig = Sheets('SAT01') 'replace sheet1 with your sheet name lnCont = 3196 For i = 2 To lnCont j = Int((lnCont - 2 + 1) * Rnd + 2) stOrig.Cells(j, 2).Copy Destination:=stOrig.Cells(i, 6) Next i Application.ScreenUpdating = True Set stOrig = Nothing End Sub.