Skip to main content

Ms Excel - Charts

Creating Charts in Excel

Choose a the collection of cells for which you want to build charts out of and select charts option near recommended charts button from insert toolbar 


And then select the type of chart that you want to build 

Moving the charts to another sheet

Select the chart and go into the design page and choose move chart , as shown below


Creating Pie charts

Choose the data that you need in to illustrate in a Pie chart and then choose pie chart option from charts bar, and customize your Pie chart by choosing on necessary attributes inside the '+' button next to the chart



They can only handle single row or single column of data.

Comments

Post a Comment

Popular posts from this blog

SQL Murder Mystery - Knight Lab

  SQL Murder mystery is a project by Knight Lab team. Which focusses on using SQL Queries to solve a case which involves in finding the killer behind a murder crime. This blog walks through the approach i did in order to find the killer behind this murder. So this is the Schema Diagram of the given tables, which we should use to figure out the killer. get_fit_now_check_in - this table gives information about checkin details of each member of the gym get_fit_now_member - this table contains information about the general details of a member of the gym person - this table contains information about the address details of the person drivers_license - this table contains information about the vehicle used by the person interview - this table contains the information regarding what the person revealed during the interview with the detectives facebook_event_checkin - this table contains information about the events the person attended and uploaded about on facebook crime_scene_report...
Post a Comment
Read more

Sigmoid Function Simplified

                             Sigmoid function Equation Definition  Technical Wikipedia Definition :  A sigmoid function is a bounded , differentiable , real function that is defined for all real input values and has a non-negative derivative at each point  and exactly one inflection point. Simple Definition - It is basically a 'S' curve or activator function which is commonly used in Machine Learning, it is used to bound/transform/squash a wide range of values within [0,1]. Basic illustration of how Sigmoid Function works, Defining the Input - Array containing 99999 equally spaced numbers between -10,10 Defining the Sigmoid Function -  Plot of the transformed values -   Graph between input and transformed output                                    ...
Post a Comment
Read more

Cdf, Pdf and P - Value Explained

The probability density function ( pdf ) and cumulative distribution function ( cdf ) are two of the most important statistical functions in reliability and are very closely related. When these functions are known, almost any other reliability measure of interest can be derived or obtained. Figure 1 Figure 2 PDF - Probability Density Function or density  of a continuous random variable , is a function  whose value at any given sample (or point) in the sample space  (the set of possible values taken by the random variable) can be interpreted as providing a relative likelihood that the value of the random variable would equal that sample In a more precise sense , the PDF is used to specify the probability of a random variable falling within a particular range of values , as opposed to taking one value.   CDF -  cumulative distribution function  ( CDF ) of a real-valued random variable   X, or just  distribution function  of  X, evalua...
Post a Comment
Read more