{"id":2912,"date":"2014-05-25T12:09:28","date_gmt":"2014-05-25T06:39:28","guid":{"rendered":"http:\/\/ucanalytics.com\/blogs\/?p=2912"},"modified":"2015-04-04T10:33:48","modified_gmt":"2015-04-04T05:03:48","slug":"excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab","status":"publish","type":"post","link":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/","title":{"rendered":"Data Visualization – Banking Case Lab : Microsoft Excel – use Secondary Axis to Create Two Y Axes"},"content":{"rendered":"
\n
\"Excel<\/a>

Excel Man – by Roopam<\/p><\/div>\n

Analytics Lab<\/span><\/h2>\n

Malcolm Gladwell in his book ‘Outliers<\/em>‘ says that it takes approximately 10,000 hours of training or practice for anybody to master a subject. There is nothing in the world that could beat hands-on practice for learning. Keeping this in mind let me start a new series on YOU CANalytics called ‘Analytics Lab’ where we will practice some of the case studies we have discussed in the past on YOU CANalytics. We will use\u00a0R and Microsoft Excel (both easily available tools) for this.<\/p>\n

It’s a bird…It’s a plane…It’s Excel man! Did I ever tell you what a super hero Excel is. In my opinion\u00a0Excel is the best tool to start learning advanced analytics! Today we will start the ‘Analytics Lab’ using concepts we have discussed in the banking case study. This time we will create a two Y axes plot by\u00a0using the secondary axis function in Excel. In the next article we will create the same plot on R.<\/p>\n

Banking Case\u00a0<\/span><\/h2>\n

Recall the banking case: in that\u00a0you were playing the role of the Chief Risk Officer (CRO) for CyndiCat bank. The bank had disbursed 60816 auto loans in the quarter between April\u2013June 2012. Additionally, you had noticed around 2.5% of overall bad rate for these loans. The idea was to identify customer segments with distinct bad rates. Bad rate, by the way, is percentage of customer defaulted on their payments. You did some exploratory data analysis (EDA) using tools of data visualization and found a relationship between age with bad rates (Part 1)<\/a>. If you recall, you have observed the following age groups wise population histogram and bad rate trend.<\/p>\n

\"Presentation1\"<\/a><\/p>\n

Using\u00a0Secondary Axis to Create Two Y Axes in Excel<\/span><\/h2>\n

A good practice is to present these two graphs in a single chart. This is useful because you and your audience don’t need to jump from one graph to another during\u00a0analysis. Let me present the data we are going to use for our purpose. I recommend you copy past this data on Excel and evaluate for\u00a0yourself the merits of a single chart in comparison to two.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Age Groups<\/strong><\/span><\/td>\nNumber of Loans<\/strong><\/span><\/td>\nBad Loans<\/strong><\/span><\/td>\nGood Loans<\/strong><\/span><\/td>\nBad Rate<\/strong><\/span><\/td>\n<\/tr>\n
21-24<\/td>\n310<\/td>\n14<\/td>\n296<\/td>\n4.5%<\/td>\n<\/tr>\n
24-27<\/td>\n511<\/td>\n20<\/td>\n491<\/td>\n3.9%<\/td>\n<\/tr>\n
27-30<\/td>\n4000<\/td>\n172<\/td>\n3828<\/td>\n4.3%<\/td>\n<\/tr>\n
30-33<\/td>\n4568<\/td>\n169<\/td>\n4399<\/td>\n3.7%<\/td>\n<\/tr>\n
33-36<\/td>\n5698<\/td>\n188<\/td>\n5510<\/td>\n3.3%<\/td>\n<\/tr>\n
36-39<\/td>\n8209<\/td>\n197<\/td>\n8012<\/td>\n2.4%<\/td>\n<\/tr>\n
39-42<\/td>\n8117<\/td>\n211<\/td>\n7906<\/td>\n2.6%<\/td>\n<\/tr>\n
42-45<\/td>\n9000<\/td>\n216<\/td>\n8784<\/td>\n2.4%<\/td>\n<\/tr>\n
45-48<\/td>\n7600<\/td>\n152<\/td>\n7448<\/td>\n2.0%<\/td>\n<\/tr>\n
48-51<\/td>\n6000<\/td>\n84<\/td>\n5916<\/td>\n1.4%<\/td>\n<\/tr>\n
51-54<\/td>\n4000<\/td>\n64<\/td>\n3936<\/td>\n1.6%<\/td>\n<\/tr>\n
54-57<\/td>\n2000<\/td>\n26<\/td>\n1974<\/td>\n1.3%<\/td>\n<\/tr>\n
57-60<\/td>\n788<\/td>\n9<\/td>\n779<\/td>\n1.1%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

The last column i.e. ‘Bad Rate’ is the percentage of ‘Bad Loans’ to ‘Number of Loans’ i.e. for the age group 21-24 it is 14\/310=4.5%.<\/p>\n

\"Slide1\"<\/a><\/p>\n

 <\/p>\n

The first thing you need to do is create a bar plot of the first two columns i.e. ‘Age Groups’ and ‘Number of Loans’. Use Column<\/strong>\u00a0in Charts <\/strong>within Insert <\/strong>tab (as shown above) to create a vertical bar plot. The default excel bar plot will look different. I have done some additional formatting for the bar plot to make it appropriate for my purpose. You could leave the default excel format for most part. The only thing you want to change is the color of the bars from default excel blue to something mellow like grey.<\/p>\n

\"Slide3\"<\/a><\/p>\n

 <\/p>\n

The next step is to add the trend line for the last column i.e. ‘Bad Rate’ on top of the above chart. For this, right click you mouse\u00a0<\/strong>anywhere on top of the above bar chart in Excel and then choose Select Data…<\/strong>You will notice a pop up window similar to the one shown below\"Slide4\"<\/a><\/p>\n

 <\/p>\n

In the above pop-up window click on Add\u00a0<\/strong>below Legend Entries (Series)<\/strong>. You will get a new pop-up window similar to the one shown below. For\u00a0series name<\/strong> choose the cell $E$1 (the cell that contain the name ‘Bad Loans’) and for series values<\/strong>\u00a0select cells $E$2 to $E$14 i.e. the values of ‘Bad Rate’\u00a0 <\/strong>for all the ‘Age Groups’.<\/p>\n

\"Slide5\"<\/a><\/p>\n

 <\/p>\n

Once you will click OK\u00a0<\/strong>in the above Edit Series\u00a0<\/strong>pop-up window, you will get\u00a0additional bars for ‘Bad Loans’. Notice, these bars are really tiny in comparison to ‘Number of Loans’ bars.<\/p>\n

\"Presentation4\"<\/a><\/p>\n

 <\/p>\n

Select any of these tiny bars for ‘Bad Rate’ by a mouse click. Then right click your mouse and choose\u00a0Format Data Series…<\/strong>You will see a pop-up window similar to the one shown below.<\/p>\n

\"Slide6\"<\/a><\/p>\n

 <\/p>\n

In the\u00a0Plot Series On <\/strong>section choose Secondary Axis <\/strong>and press Close<\/strong>\u00a0in the pop-up window. You will get a bar plot similar to the one shown below. Notice the secondary Y Axis at the right side of the plot with ‘Bad Rate’.\u00a0Remember, I have re-formatted the default Excel plot so your plot will\u00a0have different appearance. Now we are left with just one final thing.
\n\"Presentation2\"<\/a><\/p>\n

 <\/p>\n

We need to now convert the above orange bars for ‘Bad Rate’ to a line plot. This is really simple, click on the orange ‘Bad Rate’ bars and convert them to line by choosing Line\u00a0<\/strong>in\u00a0Charts <\/strong>from Insert <\/strong>tab\"Slide2\"<\/a><\/p>\n

\"Presentation3\"<\/a>Great! We are done. You might appreciate how useful it is to present these two plots in one single chart with 2 Y axes or the secondary axis in Excel. In the above chart, it is much easier to see where you have thinner data and modify your bad rates accordingly. Now, you could easily create coarse classes as discussed in the banking case study.<\/p>\n

Sign-off Note<\/span><\/h4>\n

Hope you had fun performing the above task on Excel. In the next article we will do the exactly same thing on R. See you soon!<\/p>\n

The following are the parts of the banking case study for risk scoring<\/span><\/strong>\r\n- Part 1:\u00a0Data visualization for scoring<\/a><\/span>\r\n- Part 2:\u00a0Creating ratio variables for better scoring<\/a><\/span>\r\n- Part 3:\u00a0Logistic regression<\/a><\/span>\r\n- Part 4: Information Value and Weights of Evidence<\/a><\/span>\r\n- Part 5:\u00a0Reject inference<\/a><\/span>\r\n- Part 6:\u00a0Population stability index for scorecard monitoring<\/a><\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
Analytics Lab Malcolm Gladwell in his book ‘Outliers‘ says that it takes approximately 10,000 hours of training or practice for anybody to master a subject. There is nothing in the world that could beat hands-on practice for learning. Keeping this in mind let me start a new series on YOU CANalytics called ‘Analytics Lab’ where<\/p>\n
Read More…<\/a><\/p>\n","protected":false},"author":1,"featured_media":2920,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[63,54],"tags":[8,7,6,10],"jetpack_publicize_connections":[],"yoast_head":"\nData Visualization - Banking Case Lab : Microsoft Excel - use Secondary Axis to Create Two Y Axes – YOU CANalytics |<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Visualization - Banking Case Lab : Microsoft Excel - use Secondary Axis to Create Two Y Axes – YOU CANalytics |\" \/>\n<meta property=\"og:description\" content=\"Analytics Lab Malcolm Gladwell in his book ‘Outliers‘ says that it takes approximately 10,000 hours of training or practice for anybody to master a subject. There is nothing in the world that could beat hands-on practice for learning. Keeping this in mind let me start a new series on YOU CANalytics called ‘Analytics Lab’ whereRead More...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/\" \/>\n<meta property=\"og:site_name\" content=\"YOU CANalytics |\" \/>\n<meta property=\"article:author\" content=\"roopam\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-25T06:39:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-04-04T05:03:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"298\" \/>\n\t<meta property=\"og:image:height\" content=\"448\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Roopam Upadhyay\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\",\"name\":\"YOU CANalytics\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120\",\"contentUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120\",\"width\":607,\"height\":120,\"caption\":\"YOU CANalytics\"},\"image\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#website\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/\",\"name\":\"YOU CANalytics |\",\"description\":\"Explore the Power of Data Science\",\"publisher\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ucanalytics.com\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1\",\"width\":298,\"height\":448,\"caption\":\"Excel Man - by Roopam\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#webpage\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/\",\"name\":\"Data Visualization - Banking Case Lab : Microsoft Excel - use Secondary Axis to Create Two Y Axes – YOU CANalytics |\",\"isPartOf\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#primaryimage\"},\"datePublished\":\"2014-05-25T06:39:28+00:00\",\"dateModified\":\"2015-04-04T05:03:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ucanalytics.com\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Visualization – Banking Case Lab : Microsoft Excel – use Secondary Axis to Create Two Y Axes\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#webpage\"},\"author\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6\"},\"headline\":\"Data Visualization – Banking Case Lab : Microsoft Excel – use Secondary Axis to Create Two Y Axes\",\"datePublished\":\"2014-05-25T06:39:28+00:00\",\"dateModified\":\"2015-04-04T05:03:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#webpage\"},\"wordCount\":921,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\"},\"image\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1\",\"keywords\":[\"Banking and Insurance Analytics\",\"Business Analytics\",\"Predictive Analytics\",\"Roopam Upadhyay\"],\"articleSection\":[\"Analytics Labs\",\"Risk Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6\",\"name\":\"Roopam Upadhyay\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g\",\"caption\":\"Roopam Upadhyay\"},\"description\":\"This blog contains my personal views and thoughts on predictive Analytics and big data. - Roopam Upadhyay\",\"sameAs\":[\"roopam\"],\"url\":\"https:\/\/ucanalytics.com\/blogs\/author\/roopam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Visualization - Banking Case Lab : Microsoft Excel - use Secondary Axis to Create Two Y Axes – YOU CANalytics |","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/","og_locale":"en_US","og_type":"article","og_title":"Data Visualization - Banking Case Lab : Microsoft Excel - use Secondary Axis to Create Two Y Axes – YOU CANalytics |","og_description":"Analytics Lab Malcolm Gladwell in his book ‘Outliers‘ says that it takes approximately 10,000 hours of training or practice for anybody to master a subject. There is nothing in the world that could beat hands-on practice for learning. Keeping this in mind let me start a new series on YOU CANalytics called ‘Analytics Lab’ whereRead More...","og_url":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/","og_site_name":"YOU CANalytics |","article_author":"roopam","article_published_time":"2014-05-25T06:39:28+00:00","article_modified_time":"2015-04-04T05:03:48+00:00","og_image":[{"width":298,"height":448,"url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1","type":"image\/jpeg"}],"twitter_misc":{"Written by":"Roopam Upadhyay","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/ucanalytics.com\/blogs\/#organization","name":"YOU CANalytics","url":"https:\/\/ucanalytics.com\/blogs\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/#logo","inLanguage":"en-US","url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120","contentUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120","width":607,"height":120,"caption":"YOU CANalytics"},"image":{"@id":"https:\/\/ucanalytics.com\/blogs\/#logo"}},{"@type":"WebSite","@id":"https:\/\/ucanalytics.com\/blogs\/#website","url":"https:\/\/ucanalytics.com\/blogs\/","name":"YOU CANalytics |","description":"Explore the Power of Data Science","publisher":{"@id":"https:\/\/ucanalytics.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ucanalytics.com\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#primaryimage","inLanguage":"en-US","url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1","width":298,"height":448,"caption":"Excel Man - by Roopam"},{"@type":"WebPage","@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#webpage","url":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/","name":"Data Visualization - Banking Case Lab : Microsoft Excel - use Secondary Axis to Create Two Y Axes – YOU CANalytics |","isPartOf":{"@id":"https:\/\/ucanalytics.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#primaryimage"},"datePublished":"2014-05-25T06:39:28+00:00","dateModified":"2015-04-04T05:03:48+00:00","breadcrumb":{"@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ucanalytics.com\/blogs\/"},{"@type":"ListItem","position":2,"name":"Data Visualization – Banking Case Lab : Microsoft Excel – use Secondary Axis to Create Two Y Axes"}]},{"@type":"Article","@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#article","isPartOf":{"@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#webpage"},"author":{"@id":"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6"},"headline":"Data Visualization – Banking Case Lab : Microsoft Excel – use Secondary Axis to Create Two Y Axes","datePublished":"2014-05-25T06:39:28+00:00","dateModified":"2015-04-04T05:03:48+00:00","mainEntityOfPage":{"@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#webpage"},"wordCount":921,"commentCount":0,"publisher":{"@id":"https:\/\/ucanalytics.com\/blogs\/#organization"},"image":{"@id":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1","keywords":["Banking and Insurance Analytics","Business Analytics","Predictive Analytics","Roopam Upadhyay"],"articleSection":["Analytics Labs","Risk Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/#respond"]}]},{"@type":"Person","@id":"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6","name":"Roopam Upadhyay","image":{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g","caption":"Roopam Upadhyay"},"description":"This blog contains my personal views and thoughts on predictive Analytics and big data. - Roopam Upadhyay","sameAs":["roopam"],"url":"https:\/\/ucanalytics.com\/blogs\/author\/roopam\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/photo11.jpg?fit=298%2C448&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3L0jT-KY","jetpack-related-posts":[{"id":2981,"url":"https:\/\/ucanalytics.com\/blogs\/data-visualization-banking-case-lab-2-axes-risk-plots-in-r\/","url_meta":{"origin":2912,"position":0},"title":"Data Visualization – Banking Case Lab: 2 Axes Risk Plots in R","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Analytics Lab - R Welcome back to Analytics Lab on YOU CANalytics! In our last article, we learned the procedure to visualize risk across a parameter (age groups) in Excel. In this part we will generate the same visualization in R. This lab exercise is a part of the banking\u2026","rel":"","context":"In "Analytics Labs"","block_context":{"text":"Analytics Labs","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-labs\/"},"img":{"alt_text":"Presentation3","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation3.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation3.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation3.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":281,"url":"https:\/\/ucanalytics.com\/blogs\/credit-scorecards-predictive-analytics-part-7\/","url_meta":{"origin":2912,"position":1},"title":"Credit Scorecards –  Business Integration of Predictive Analytics (part 7 of 7)","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Columbus - A lesson in Leadership Christopher Columbus \u2013 I have adored this man for various reasons at various stages of my life. At seven, I adored him because his mistakes were applauded and became part of history \u2013 Columbus mistook Native Americans for Indians because he thought he had\u2026","rel":"","context":"In "Credit Risk Analytics Series"","block_context":{"text":"Credit Risk Analytics Series","link":"https:\/\/ucanalytics.com\/blogs\/category\/risk-analytics\/credit-risk-analytics-series\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/7-Leader-225x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":9619,"url":"https:\/\/ucanalytics.com\/blogs\/podcast-interview-roopam\/","url_meta":{"origin":2912,"position":2},"title":"Podcast of an Interview with Roopam","author":"Swati Patankar","date":false,"format":false,"excerpt":"Hello to the readers of YOU CANalytics from Swati Patankar, the editor of the blog. I am a scientist who is currently on sabbatical from my academic job. As part of this, I am exploring how to make science interesting through\u00a0podcasts. Roopam very kindly agreed to be my first guinea\u2026","rel":"","context":"In "Events & Interviews"","block_context":{"text":"Events & Interviews","link":"https:\/\/ucanalytics.com\/blogs\/category\/events-and-interviews\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2017\/01\/Interview-Swati-and-Roopam-YOU-CANalytics.jpg?fit=730%2C525&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2017\/01\/Interview-Swati-and-Roopam-YOU-CANalytics.jpg?fit=730%2C525&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2017\/01\/Interview-Swati-and-Roopam-YOU-CANalytics.jpg?fit=730%2C525&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2017\/01\/Interview-Swati-and-Roopam-YOU-CANalytics.jpg?fit=730%2C525&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2783,"url":"https:\/\/ucanalytics.com\/blogs\/in-conversation-with-eric-siegel-author-predictive-analytics\/","url_meta":{"origin":2912,"position":3},"title":"In Conversation with Eric Siegel: Author ‘Predictive Analytics’","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"In Conversation with.. Today we are starting a new series on YOU CANalytics called 'in conversation with'. In this series we will talk to the leaders and experts of predictive analytics and big data to gain deeper insight into the field. Dr. Eric Siegel Our first guest for the series\u2026","rel":"","context":"In "Events & Interviews"","block_context":{"text":"Events & Interviews","link":"https:\/\/ucanalytics.com\/blogs\/category\/events-and-interviews\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/12\/Slide15.jpg?fit=290%2C210&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":6013,"url":"https:\/\/ucanalytics.com\/blogs\/data-analytics-challenge-solve-the-case-of-shady-gambler\/","url_meta":{"origin":2912,"position":4},"title":"Data Analytics Challenge 1(Clue # 1) : Solve the Case of a Shady Gambler","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Data! data! data!\" he cried impatiently. \"I can't make bricks without clay. - Sherlock Holmes In this article, we are starting a new series on YOU CANalytics that can't proceed without your\u00a0participation to solve the data analytics mysteries. In the beginning of each article of this series, you will get\u2026","rel":"","context":"In "Analytics Challenge"","block_context":{"text":"Analytics Challenge","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-challenge\/"},"img":{"alt_text":"Mystery Challenge plot","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=700%2C400 2x"},"classes":[]},{"id":2374,"url":"https:\/\/ucanalytics.com\/blogs\/learn-r-12-books-and-online-resources\/","url_meta":{"origin":2912,"position":5},"title":"Learn R : 12 Free Books and Online Resources","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Please read the disclaimer about the Free PDF Books in this article at the bottom R, an open-source statistical and data mining programming language, is slowly but surely catching up in its race with commercial software like SAS & SPSS. I believe R will eventually replace SAS as the language\u2026","rel":"","context":"In "Analytics Book Club"","block_context":{"text":"Analytics Book Club","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-book-club\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/5-Swordsmith1.jpg?fit=768%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/5-Swordsmith1.jpg?fit=768%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/5-Swordsmith1.jpg?fit=768%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/5-Swordsmith1.jpg?fit=768%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts\/2912"}],"collection":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/comments?post=2912"}],"version-history":[{"count":0,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts\/2912\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/media\/2920"}],"wp:attachment":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/media?parent=2912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/categories?post=2912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/tags?post=2912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}