PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CHARTS are the graphic representation of any data . As we know that EXCEL is a super analytical tool.
Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.
The button for funnel chart is found under the INSERT TAB under the CHARTS SECTION. The button is Insert Waterfall, Funnel, Stock, Surface or Radar chart. The location is shown in the picture below.
STAGE | VALUE |
STAGE 1 | 1000 |
STAGE 2 | 845 |
STAGE 3 | 700 |
STAGE 4 | 550 |
STAGE 5 | 220 |
The procedure to insert a FUNNEL chart are as follows:
So , we have successfully created a FUNNEL CHART in Excel.
The chart can be easily made and modified as per requirement.
We should use the chart only when a certain process fulfills our requirements as discussed in the section above.
The process should have the values decreasing otherwise the relevance of the chart will be no more.
After applying the styles , the final chart is shown below.
FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN EXCEL].
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE