In this post, I’ll show you how you can add secondary axis in a chart in Excel 2010:
First up, Why do you need secondary axis?
Look at the Data and the chart that I just created:
Notice something? Column A is not “visible” – Is it? So Now let’s see the effect how adding a Secondary Axes:
Looks better? Here are the steps:
1. Select the chart
2. can you see charts tool options in the menu bar? Yes? Great!
3. Switch to Format Tab
4. select the column that you want to put on a secondary axes:
5. After selecting the column, click on Format Selection
6. In the dialog box, select secondary axes:
click on close.
7. Can you see the secondary axis now? Great!
8. Let’s do one more thing!
Let’s change the chart type of the secondary axis. Here are the steps:
a. Make sure the column is selected from the format Tab
b. Switch to the Design Tab under the charts Tool
c. Click on change chart type and select the chart of your choice. I select a column chart and this is how it looks:
In this post, we saw how to add a secondary axis. We also saw how to change the chart type of the secondary axis.
I learned about an interesting new feature in Excel 2013 which they call “FLASH FILL”. Instead of trying to explain it, Let me demo it:
1. I’ve following data in Excel 2013:
2. Now the requirement is to split the FULL NAME into FIRST NAME and LAST NAME.
So I entered Kim in cell B2
Then I typed just Mi in the cell B3 and Excel 2013 predicts correctly for cell B3, B4 and B5 that I am filling up the first name from the Full Name column.
I hit enter for the column First Name.
I performed similar steps for the column Last Name. And there you have it:
That’s about it for demo of Excel 2013′s Flash Fill – very cool!
I’ve posted how to split the values in a column for Excel 2010, you can read that here: How to split the content of one excel cell into separate columns?
Your comments are very welcome!
In this post, we would see how to get started with Fuzzy look-up add-in for excel.
First up, Which problem does Fuzzy Lookup add-in for excel solve? It cleans similar (a.k.a matching) textual data in Excel. E.g. “Mr Paras Doshi”, “Doshi Paras”, “Paras A Doshi” are similar and may refer to the same person – Fuzzy look-up helps you detect such similar textual data. This add-in is really handy if you are “combining” data from different systems where the data is not in the same format – using this add-in you can detect similar looking text and clean the data-set at hand. With that, Here are the steps to download, install and play with this add-in:
1) Download “Fuzzy Lookup add-in for Excel. Read: Over view, system requirements and Instructions
(If this doesn’t work – search for “Fuzzy lookup add in for excel”
2) Note the sample excel file called “Portfolio” that comes with the download files. We’ll open it after the Successful installation of the add-in:
I left the default on all dialog boxes.
4) Open the sample file: “portfolio“
5) Click on Install if you see a dialog box “Microsoft Office customization folder”
(please read the message in the dialog box too)
6) Can you see Fuzzy Lookup in Excel Toolbar? Yes? Great!
7) Now if you have opened the Portfolio file then you’ll see a tutorial on how to get started on the worksheet named portfolio:
8) follow the above tutorial to get started. I just did!
In this post, we saw how Fuzzy Lookup add-in for excel 2010 help you find matching text from two data sources. I hope that helps.
A short post to point out that Power View reports can be exported to PowerPoint (PPT) – and PPT slides would also have a “click to interact” button and if the security plus network access is configured correctly then the Interactive data exploration without leaving the Slides! very cool. I had pointed this fact out earlier here. And the official resource can be found here: Export a Power View Report to PowerPoint
I am referring to SQL Server 2012 BI and SharePoint 2010 here. And here is a step by step guide:
1) Create report > Save it > And then Go to File > Export to Power Point
A note about security: “Export to PowerPoint” requires windows authentication method.
2) Select the location of the PPT file that will have the “Power View” reports.
Now you can store the PowerPoint file at any place but it would be important to consider whether the machine from which it would be accessed has the network access to the SharePoint Power View reports. If not, the Power View reports would just show up as “static images” and the click to interact would not work. Important security point to consider for your scenario.
3) Open the File > start slideshow > Navigate to the slide (if applicable) > can you see the “click to Interact” button? Yes? Great! you can do interactive data exploration from the PowerPoint environment itself! I find this very Impressive because Power View is meant for Business Users to do Data Exploration and create rich visualizations and once they are done with it – they can export it to PowerPoint and show their Power View chops to their boss and peers and more importantly, make better business decisions. Any-how, here’s the image:
That’s about it!