In this set of tutorials, we will be learning how to create Advanced charts in Excel
List of advanced charts in excel:
Box plot in Excel : A measure of how well distributed the data is .
Bubble chart in Excel: Bubble Chart is the variation of Scatter chart and its data is plotted as bubble .When a data has three series of values then it can represented with the help of bubble chart.
STAR Rating in Excel: We will be learning how to create star rating in Excel. we will be using the standard five star rating procedure
Gantt Chart in Excel: Gantt charts is an easy way to visualize project management timelines by transforming task names, start dates, durations, and end dates into cascading horizontal bar charts.
pie of pie chart in Excel: When we need to represent the percentage distribution across categories we generally use Pie chart. When there is too much of categories with very less percentage distribution then the pie chart becomes quite messy. In that case we use Pie of Pie chart.
Sparklines in Excel: Sparklines in Excel are actually a tiny chart in the background of a cell. SparkLines in Excel are used to understand the pattern of data at a quick glance.
win Loss chart in Excel: Win Loss Chart provides a quick way of visualizing a series of data at one glance, with the help of Win Loss chart in excel one can easily represent the positive or negative polarity through Spark lines.
Waterfall Chart in Excel: A waterfall chart is a special type of column chart used for understanding how an initial value is affected by a series of intermediate positive or negative values.
Stock Chart in Excel: Stock charts, as the name indicates, are useful to show fluctuations in stock prices.These charts are useful to show fluctuations in other data also, such as daily rainfall or annual temperatures
Funnel Chart in Excel: A funnel chart displays values as progressively decreasing proportions amounting to 100 percent in total.
Thermometer chart in Excel: Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value
Power Map in Excel: Microsoft Power Map in Excel is a three-dimensional (3-D) data visualization tool that lets you look at information across Geographical location.
Pareto Chart in Excel: Pareto charts are a combination of a line graph and a bar graph. Bar Graph indicates the value and Line Graph indicates the cumulative percentage.
Lets Learn How to create these advanced charts in excel in coming chapters