On the Insert tab, under Charts group, select Recommended Charts or choose any chart type of your choice.Select the range of data you want to create chart on.Used to combine two charts for two different values to highlight different types of information Use to display the trend of stocks or forex over time, especially when there are different price values Use to show values relative to a center point Use to show trend values across two dimensions
Use for financial data to show the cumulative effect of a series of positive and negative values Use to show the relationship between two sets of data
Use to display the variations within data categories Use to compare values arranged hierarchically using a ring, especially when there are many categories of data
Use to compare values arranged hierarchically using different rectangular levels, especially, when there are few categories The whole equals 100%, each proportion is derived from the 100%. Use to show the proportion of a category from the whole. Use to display trend values, especially, when there is a need to highlight the magnitude of change over time. Use to display trend values over time, especially, when there are many data points Use to compare values across different categories, especially, when categories name is long Use to compare values across different categories