This is as shown in the below screenshot. Select the data over which the chart needs to be built, and then from the other chart option, select the required option from the two doughnut options. This chart is a type of pie chart, only that it is represented in the shape of a doughnut. When the chart is built, it looks like as shown below. Each chart option in the Stock chart requires a different set of inputs. This chart requires that stocks’ Opening, High, low, and Closing Prices be defined in the order. To build a stock chart, select the data and the requisite stock chart option, as shown in the following screenshot.Īs can be seen in the above screenshot, the Open-High-Low-Close stock chart. ![]() These are special types of charts that are used for stock price analysis. As we can see, the pattern formed by the scatter plot allows us to derive insights based on the context. To build a scatter plot, select the data and then the requisite scatter plot option, as seen in the following screenshot.įollowing the above procedure leads to the creation of a scatter plot. The chart requires two series and takes corresponding individual values as x and y coordinates. This chart helps in determining the relation between two variables. The area chart gives us a quick insight into the sales trend over the quarters for the three cities. As a result, we got the following chart, as shown in the screenshot. To generate an area chart, we shall follow the steps in the screenshot below.Īs we can see above, we selected the requisite range, and then we selected the requisite Area chart option from the Area option. The chart makes use of areas to present the data. This chart represents the trend of a measure for various categories over time. We can use this visualization to compare sales for three cities for four quarters. To build a horizontal bar, select the bar chart option from the Bar option, as shown in the following screenshot.Īs we can see in the above screenshot, we selected clustered bar in 3-D, which gave us a clustered 3-D bar graph, as shown in the following screenshot. This chart type is no different than a column chart, only that we have horizontal bars here. The pie chart gives us a quick insight into the percentage contribution. To create a pie chart, select the requisite columns, and click on the required pie chart option from the Pie option as shown below.Īs a result of following the above procedure, a pie chart is created, which can be seen below. ![]() E.g., we shall build a pie chart to determine each quarter’s percentage contribution to total sales. The pie Chart gives the contribution of a category. First, to build a line chart, select the data, and then select the requisite line chart option, as shown below.įollowing the above procedure leads to creating a line chart, as shown in the screenshot below. E.g., in this case, we have quarter-wise data for two cities, and we shall compare the sales trend over the quarters for these two cities. This chart is useful for observing trends. It is a very simple column chart that gives us region-wise total sales. When we follow the above procedure, a column chart is created, as shown in the below screenshot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |