Tutorial on Advanced charts in Excel

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 .Tutorial on Advanced charts in Excel 1

 

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.Tutorial on Advanced charts in Excel 2

 

STAR Rating in Excel:  We will be learning how to create star rating in Excel. we will be using the standard five star rating procedureTutorial on Advanced charts in Excel 3

 

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.Tutorial on Advanced charts in Excel 4

 

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.

Tutorial on Advanced charts in Excel 5

 

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.Tutorial on Advanced charts in Excel 6

 

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.Tutorial on Advanced charts in Excel 7

 

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 temperaturesTutorial on Advanced charts in Excel 8

 

Funnel Chart in Excel: A funnel chart displays values as progressively decreasing proportions amounting to 100 percent in total.Tutorial on Advanced charts in Excel 10

 

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 valueTutorial on Advanced charts in Excel 9

 

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.

Tutorial on Advanced charts in Excel 12

 

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.Tutorial on Advanced charts in Excel 9

Lets Learn How to create these  advanced charts in excel in coming chapters

next small advanced charts in Excel