Add a secondary y axis to a graph in excel for mac

#ADD A SECONDARY Y AXIS TO A GRAPH IN EXCEL FOR MAC SERIES#

The default excel bar plot will look different. Use ColumnВ in Charts within Insert tab (as shown above) to create a vertical bar plot.

The first thing you need to do is create a bar plot of the first two columns i.e. вЂBad RateвЂ™ is the percentage of вЂBad LoansвЂ™ to вЂNumber of LoansвЂ™ i.e. I recommend you copy past this data on Excel and evaluate forВ yourself the merits of a single chart in comparison to two. Let me present the data we are going to use for our purpose. This is useful because you and your audience donвЂ™t need to jump from one graph to another duringВ analysis. UsingВ Secondary Axis to Create Two Y Axes in ExcelДЄ good practice is to present these two graphs in a single chart. If you recall, you have observed the following age groups wise population histogram and bad rate trend. You did some exploratory data analysis (EDA) using tools of data visualization and found a relationship between age with bad rates (Part 1). Bad rate, by the way, is percentage of customer defaulted on their payments. The idea was to identify customer segments with distinct bad rates. Additionally, you had noticed around 2.5% of overall bad rate for these loans. The bank had disbursed 60816 auto loans in the quarter between AprilвЂ“June 2012. Recall the banking case: in thatВ you were playing the role of the Chief Risk Officer (CRO) for CyndiCat bank. In the next article we will create the same plot on R. This time we will create a two Y axes plot byВ using the secondary axis function in Excel. In my opinionВ Excel 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. ItвЂ™s a birdвЂ¦ItвЂ™s a planeвЂ¦ItвЂ™s Excel man! Did I ever tell you what a super hero Excel is. We will useВ R and Microsoft Excel (both easily available tools) for this.

#ADD A SECONDARY Y AXIS TO A GRAPH IN EXCEL FOR MAC SERIES#

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. There is nothing in the world that could beat hands-on practice for learning. Malcolm Gladwell in his book вЂ OutliersвЂ says that it takes approximately 10,000 hours of training or practice for anybody to master a subject.

Add a secondary y axis to a graph in excel for mac