A column chart shows data changes over a period of time or illustrates comparisons among items. Column charts have the following chart sub-types:

• Clustered Column shows how to set the appearance properties of a Clustered Column chart.

D e t a i l s

This Demo exhibits how to create a Clustered Column chart in a worksheet. This type of chart compares values across categories. Normally the categories are organized horizontally, and values vertically, to emphasize variation over time. Aspose.Cells component is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Clustered Column. The component can insert a chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first two columns (A and B) of the first worksheet. The first column represents the category data (Region) and the second column represents values (Marketing Costs). The demo creates the chart representing Marketing Costs By Region based on the different costs involving different regions. In the example, you have been provided a sample snapshot of the chart and a few controls that represent the related list of data including two text boxes which represent category axis and value axis titles, five drop down lists which represent major unit, minor unit, minimum, maximum values of value axis and gap width that represents the space b/w the column clusters in the chart and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Stacked Column shows how to set the appearance properties of a Stacked Column chart.

D e t a i l s

This Demo describes how to create a Stacked Column chart with simple and 3-D visual effects in a worksheet. This type of chart shows the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Stacked Column. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first three columns (A, B and C) of the first worksheet named Data. The first column represents the category data (Year) where as the second and third column represent values for Product1 and Product2. The demo creates a stacked column chart representing Product Sales into the second worksheet named Chart based on the different product values related to different years (2004-2006) in the first worksheet. In the example, you have been provided a sample snapshot of the chart, a check box that represents whether you want to create a 3-D stacked column chart and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• 100% Stacked Column shows how to set the appearance properties of a 100% Stacked Column chart.

D e t a i l s

This Demo demonstrates how to create a 100% Stacked Column chart with simple and 3-D visual effects in a worksheet. This type of chart compares the percentage each value contributes to a total across categories. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including 100% Stacked Column. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first five columns (A, B, C, D and E) of the first worksheet named Data. The first column represents the product names (Product1, Product2 and Product3) where as the second, third, fourth and fifth columns represent percentage values involving different quarters (Qurarter1, Quarter2, Quarter3 and Quarter4) which represent category data. The demo creates a 100% stacked column chart representing Product Contribution to Total Sales into the second worksheet named Chart based on the different product values related to different quarters in the first worksheet. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D flavor and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• 3D Column shows how to set the appearance properties of a 3D Column chart.

D e t a i l s

This Demo exhibits how to create a 3-D Column chart with simple, clustered and stacked flavors in a worksheet. This type of chart compares data points along two axes. Aspose.Cells component is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including 3-D Column. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first two columns (A and B) of the first worksheet. The first column represents the category data (Region) and the second column represents values (Marketing Costs). The demo creates a 3-D column chart representing Marketing Costs By Region based on the different costs involving different regions. In the example, you have been provided a sample snapshot of the chart and a few controls that represent the related list of chart data including a text box which represents chart type, five drop down lists which represent wall color, floor color, rotation angle, elevation angle and depth in percentage and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

A bar chart illustrates comparisons among individual items. Bar charts have the following chart sub-types:

• Clustered Bar shows how to set the appearance properties of a Clustered Bar chart as 2D or 3D.

D e t a i l s

This Demo exhibits how to create a Clustered Bar chart with 2-D and 3-D visual effects in a worksheet. This type of chart compares values across categories. Normally, categories are organized vertically, and values horizontally, to place focus on comparing the values. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Clustered Bar. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the source data related chart into the first three columns (A, B and C) of the first worksheet. The first column represents the category data (Region) where as the second and third columns represent the sales data representing values related to the products (Apple and Orange). The demo creates a clustered bar chart representing Fruit Sales By Region into the first worksheet named Clustered Bar based on the different product values related to different regions. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D flavor and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Stacked Bar shows how to set the appearance properties of a Stacked Bar chart as 2D or 3D.

D e t a i l s

This Demo exhibits how to create a Stacked Bar chart with 2-D and 3-D visual effects in a worksheet. This type of chart shows the relationship of individual items to the whole. It is also available with a 3-D visual effect. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Stacked Bar. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the source data related chart into the first four columns (A, B, C and D) of the first worksheet named Data. The first column represents the category data (Region) where as the second, third and fourth columns represent the sales data representing values related to different products (Apple, Orange and Banana). The demo creates a Stacked Bar chart representing Fruit Sales By Region into the second worksheet named Chart based on the different product values related to different regions in the first worksheet. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D visual effect and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• 100 % Stacked Bar shows how to set the appearance properties of a 100% Stacked Bar.

D e t a i l s

This Demo demonstrates how to create a 100% Stacked Bar chart with simple and 3-D visual effects in a worksheet. This type of chart compares the percentage each value contributes to a total across categories. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including 100% Stacked Bar. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first five columns (A, B, C, D and E) of the first worksheet named Data. The first column represents the product names (Product1, Product2 and Product3) where as the second, third, fourth and fifth columns represent percentage values involving different quarters (Qurarter1, Quarter2, Quarter3 and Quarter4) which represent category data. The demo creates a 100% stacked bar chart representing Product Contribution to Total Sales into the second worksheet named Chart based on the different product values related to different quarters in the first worksheet. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D visual effect and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

A line chart shows trends in data at equal intervals. Line charts have the following chart sub-types:

• Line shows how to create Line chart that displays trends over time or categories. 

D e t a i l s

This Demo exhibits how to create a Line chart in a worksheet. This type of chart displays trends over time or categories. It is also available with markers displayed at each data value. Aspose.Cells component supports all the standard and custom charts including Line chart to help you display data in more meaningful ways. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the source data related chart into the first six columns (A, B, C, D, E and F) of the first worksheet named Line. The first column presents different regions where as the second, third, fourth, fifth and sixth columns represent the sales data representing values involving different years (2002 - 2006). The demo creates a Line chart representing Sales By Region For Years into the worksheet based on the different sales values of different regions in different years. In the example, you are provided a sample snapshot of the chart, a few controls including five drop down lists which represent chart type (Line and LineWithDataMarker), marker style (Square, Triangle, Diamond, Circle, Dash, Dot, None etc.), marker background color, marker foreground color, marker size and a command button labeled Create Report to create and exercise the chart based on your selection from the drop down lists. You are allowed to either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Stacked Line   shows how to create Stacked Line chart that displays the trend of the contribution of each value over time or categories.

D e t a i l s

This Demo demonstrates how to create a Stacked Line chart in a worksheet. This type of chart displays the trend of the contribution of each value over time or categories. It is also available with markers displayed at each data value. Aspose.Cells component supports all the standard and custom charts including Stacked Line chart to help you display data in more meaningful ways. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the source data related chart into the first six columns (A, B, C, D, E and F) of the first worksheet named Data. The first column represents different regions where as the second, third, fourth, fifth and sixth columns represent the sales data representing values involving different years (2002 - 2006). The demo creates a stacked line chart representing Sales By Region For Years into the second worksheet named Chart based on the different sales values of different regions in different years in the first worksheet. In the example, you are provided a sample snapshot of the chart, a drop down list which represents whether you want to create the chart with data markers and a command button labeled Create Report to create and exercise the chart based on your selection from the drop down list. You can either open the resultant excel file(s) into MS Excel or save directly to your disk.

• 100% Stacked Line  shows how to create 100% Stacked Line chart displays the trend of the percentage each value contributes over time or categories.

D e t a i l s

This Demo demonstrates how to create a 100% Stacked Line chart in a worksheet. This type of chart displays the trend of the percentage each value contributes over time or categories. It is also available with markers displayed at each data value. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including 100% Stacked Line. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first five columns (A, B, C, D and E) of the first worksheet named Data. The first column represents the product names (Product1, Product2 and Product3) where as the second, third, fourth and fifth columns represent percentage values involving different quarters (Qurarter1, Quarter2, Quarter3 and Quarter4). The demo creates a 100% stacked line chart representing Product contribution to total sales into the second worksheet named Chart based on the different product values related to different quarters in the first worksheet. In the example, you have been provided a sample snapshot of the chart, a drop down list that represents whether you want to create the chart with data markers and a command button labeled Create Report to create and exercise the chart based on the selection from the drop down list. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• 3D Line  shows how to create a 3-D Line chart.

D e t a i l s

This Demo exhibits how to create a Line chart with a 3-D visual effect in a worksheet. Aspose.Cells component supports all the standard and custom charts including 3-D Line chart to help you display data in more meaningful ways. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first six columns (A, B, C, D, E and F) of the first worksheet named 3D Line. The first column presents different regions where as the second, third, fourth, fifth and sixth columns represent the sales data representing values involving different years (2002 - 2006). The demo creates a 3-D Line chart representing Sales By Region into the worksheet based on the different sales values of different regions in different years. In the example, you are provided a sample snapshot of the chart, a few controls including four drop down lists which represent major tick mark type (None, Inside, Outside and Cross) and minor tick mark type (None, Inside, Outside and Cross) for values, value labels rotation angle and category labels rotation angle and a command button labeled Create Report to create and exercise the chart based on your selection from the drop down lists. You are allowed to either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

A pie chart shows the size of items that make up a data series ,proportional to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element in the data. Pie charts have the following chart sub-types:

• Pie shows how to create a Pie chart that displays the contribution of each value to a total.

D e t a i l s

This Demo exhibits how to create a Pie chart with 2-D and 3-D visual effects in a worksheet. This type of chart displays the contribution of each value to a total. It is also available with a 3-D visual effect. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Pie. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first two columns (A and B) of the first worksheet. The first column represents the category data (Region) where as the second column represents the sales data representing values. The demo creates a pie chart representing Sales By Region into the worksheet named Pie based on the different sale values related to different regions. In the example, you are provided a sample snapshot of the chart, two drop down lists which represent first slice angle (90, 80, 180 and 360) and data label position (Center, InsideBase, InsideEnd and OutSideEnd), a check box that represents whether you want to create the chart with 3-D flavor and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Exploded Pie shows how to create an Exploded Pie chart that displays the contribution of each value to a total while emphasizing individual values.

D e t a i l s

This Demo exhibits how to create an Exploded Pie chart with 2-D and 3-D visual effects in a worksheet. This type of chart displays the contribution of each value to a total while emphasizing individual values. It is also available with a 3-D visual effect. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Exploded Pie. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first two columns (A and B) of the first worksheet named Data. The first column represents the category data (Region) where as the second column represents the sales data representing values. The demo creates an exploded pie chart representing Sales By Region into the second worksheet named Chart based on the different sale values related to different regions in the first worksheet. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D flavor and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Pie of Pie shows how to create Pie of Pie chart with user-defined values extracted and combined into a second pie.

D e t a i l s

This Demo exhibits how to create a Pie of Pie chart in a worksheet. This is a pie chart with user-defined values extracted and combined into a second pie. For example, to make small slices easier to see, you can group them together as one item in a pie chart and then break down that item in a smaller pie next to the main chart. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Pie of Pie. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first two columns (A and B) of the first worksheet named Data. The first column represents the category data (Region) where as the second column represents the sales data representing values. The demo creates a pie of pie chart representing Sales By Region into the second worksheet named Chart based on the different sale values related to different regions in the first worksheet. In the example, you are provided a sample snapshot of the chart and a command button labeled Create Report to create the chart. You can either open the resultant excel file into MS Excel or save directly to your disk.

• Bar of Pie shows how to create Bar of Pie chart with user-defined values extracted and combined into a stacked bar.

D e t a i l s

This Demo exhibits how to create a Bar of Pie chart in a worksheet. This is a pie chart with user-defined values extracted and combined into a stacked bar. For example, to make small slices easier to see, you can group them together as one item in a pie chart and then break down that item in a smaller bar next to the main chart. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Bar of Pie. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first two columns (A and B) of the first worksheet named BarofPie. The first column represents the category data (Region) where as the second column represents the sales data representing values. The demo creates a bar of pie chart representing Sales By Region into the worksheet based on the different sale values related to different regions. In the example, you are provided a sample snapshot of the chart and a command button labeled Create Report to create the chart. You can either open the resultant excel file into MS Excel or save directly to your disk.

An xy (scatter) chart shows the relationships among the numeric values in several,or plots two groups of numbers as one series of xy coordinates.

• Scatter  shows how to create Scatter chart based on uneven intervals (or clusters) of two sets of data.

D e t a i l s

This Demo demonstrates how to create a Scatter chart in a worksheet. This type of chart compares pairs of values. The example creates a scatter chart which shows uneven intervals (or clusters) of two sets of data. When you arrange your data for a scatter chart, place x values in one row or column, and then enter corresponding y values in the adjacent rows or columns. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Scatter chart. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first two columns (A and B) of the first worksheet named Scatter. The first column provides Daily Rainfall that represents the x values where as the second column denotes Particulate that represents the y values. The demo creates a scatter chart representing Particulate Levels in Rainfall into the worksheet based on the x and y values. In the example, you are provided a sample snapshot of the chart and a command button labeled Create Report to create and exercise the chart. You can either open the resultant excel file into MS Excel or save directly to your disk.

• Scatter with Data Points Connected by Lines  shows how to create Scatter chart with or without straight or smoothed connecting lines between data points.

D e t a i l s

This Demo exhibits how to create a Scatter chart connected by lines / curves with or without data markers in a worksheet. This type of chart compares pairs of values. This type of chart can be displayed with or without straight or smoothed connecting lines between data points. These lines can be displayed with or without markers. The example creates a scatter chart with connected lines / curves with or without data markers which shows uneven intervals (or clusters) of two sets of data. When you arrange your data for a scatter chart, place x values in one row or column, and then enter corresponding y values in the adjacent rows or columns. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including all types of Scatter chart. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs chart related source data into the first two columns (A and B) of the first worksheet named Data. The first column provides Daily Rainfall that represents the x values where as the second column denotes Particulate that represents the y values. The demo creates a scatter chart representing Particulate Levels in Rainfall into second worksheet named Chart based on the x and y values in the first worksheet. In the example, you are provided a sample snapshot of the chart, a drop down list which represents different types of scatter chart and a command button labeled Create Report to create and exercise the chart based on the type you selected. You are allowed to either open the resultant excel file(s) into MS Excel or save directly to your disk.

An area chart emphasizes the magnitude of change over time. Area charts have the following chart sub-types:

• Area shows how to create Area chart that displays the trend of values over time or categories.

D e t a i l s

This Demo exhibits how to create Area chart with 2-D and 3-D flavors in a worksheet. This type of chart displays the trend of values over time or categories. It is also available with a 3-D visual effect. By displaying the sum of the plotted values, an area chart also shows the relationship of parts to a whole. For example, the following area chart emphasizes increased sales in different regions and illustrates the contribution of each country to total sales. Aspose.Cells component supports all the standard and custom charts including Area chart to help you display data in more meaningful ways. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the source data related chart into the first six columns (A, B, C, D, E and F) of the first worksheet named Area. The first column represents the category data (Region) where as the second, third, fourth, fifth and sixth columns represent the sales data representing values involving different years (2002 - 2006). The demo creates an area chart representing Sales By Region into the worksheet based on the different sales values related to different regions. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D visual effect and a command button labeled Create Report to create and exercise the chart. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Stacked Area shows how to create Stacked Area chart that displays the trend of the contribution of each value over time or categories.

D e t a i l s

This Demo exhibits how to create a Stacked Area chart with 2-D and 3-D flavors in a worksheet. This type of chart displays the trend of the contribution of each value over time or categories. It is also available with a 3-D visual effect. Aspose.Cells component supports all the standard and custom charts including Stacked Area chart to help you display data in more meaningful ways. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the source data related chart into the first six columns (A, B, C, D, E and F) of the first worksheet named Data. The first column represents the category data (Region) where as the second, third, fourth, fifth and sixth columns represent the sales data representing values involving different years (2002 - 2006). The demo creates a stacked area chart representing Total Sales into the second worksheet named Chart based on the different sales values related to different regions in the first worksheet. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D visual effect and a command button labeled Create Report to create and exercise the chart. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• 100% Stacked Area shows how to creates 100% Stacked Area chart that displays the trend of the percentage each value contributes over time or categories.

D e t a i l s

This Demo demonstrates how to create a 100% Stacked Area chart with simple and 3-D visual effects in a worksheet. This chart type displays the trend of the percentage each value contributes over time or categories. It is also available with a 3-D visual effect. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including 100% Stacked Area. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first five columns (A, B, C, D and E) of the first worksheet named Data. The first column represents the product names (Product1, Product2 and Product3) where as the second, third, fourth and fifth columns represent percentage values involving different quarters (Qurarter1, Quarter2, Quarter3 and Quarter4) which represent category data. The demo creates a 100% stacked area chart representing Product contribution to total sales into the second worksheet named Chart based on the different product values related to different quarters in the first worksheet. In the example, you are provided a sample snapshot of the chart, a check box that represents whether you want to create the chart with 3-D visual effect and a command button labeled Create Report to create and exercise the chart using your desired inputs. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

Like a pie chart, a doughnut chart shows the relationship of parts to a whole; however, it can contain more than one data series. Doughnut charts have the following chart sub-types:

• Doughnut shows how to create a Doughnut chart that displays data in rings.

D e t a i l s

This Demo describes how to create a Doughnut chart in a worksheet. This type of chart displays data in rings, where each ring represents a data series. For example, in the following chart, the inner ring represents 2005 fruit sales, and the outer ring represents 2006 fruit sales. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Doughnut. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first three columns (A, B and C) of the first worksheet named Doughnut. The first column represents the products (Apple and Orange ) where as the second and third columns represent the sales data involving different years representing values. The demo creates a doughnut chart representing Fruit Sales by Region For Years into the worksheet based on the different fruit sale values related to different years. In the example, you are provided a sample snapshot of the chart and a command button labeled Create Report to create the chart. You can either open the resultant excel file into MS Excel or save directly to your disk.

• Exploded Doughnut shows how to create an Exploded Doughnut chart which is like an Exploded Pie chart but it can contain more than one data series.

D e t a i l s

This Demo describes how to create an Exploded Doughnut chart in a worksheet. This chart type is like an exploded pie chart, but it can contain more than one data series. This type of chart displays the contribution of each value to a total while emphasizing individual values. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Exploded Doughnut. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs the chart source data into the first two columns (A and B) of the first worksheet named Data. The first column denotes the category data that represents the products (Apple and Orange ) where as the second column represents the yearly sales data that mentions values. The demo creates an exploded doughnut chart representing Fruit Sales by Region For Years into the second worksheet named Chart based on the different fruit sale values in the first worksheet. In the example, you are provided a sample snapshot of the chart and a command button labeled Create Report to create the chart. You can either open the resultant excel file into MS Excel or save directly to your disk.

A radar chart compares the aggregate values of a number of data series. Radar charts have the following chart sub-types:

• Radar shows how to create Radar chart that displays changes in values relative to a center point.

D e t a i l s

This Demo demonstrates how to create a Radar chart in a worksheet. This type of chart displays changes in values relative to a center point. It can be displayed with markers for each data point. For example, in the following radar chart, the data series that covers the most area, Brand A, represents the brand with the highest vitamin content. Aspose.Cells is a powerful component, which supports all the standard and custom charts to help you display data in more meaningful ways. You may create many kinds of charts including Radar. The component can create the chart into the worksheet in a workbook using the simplest APIs with ease. The demo creates a workbook first and inputs some chart related data into the first seven columns (A, B, C, D, E, F and G) of the first worksheet named Radar. The first column represents the different brands (Brand A, Brand B and Brand C) where as the second, third, fourth, fifth, sixth and seventh columns represent percentage values related to vitamins (Vitamin A, Vitamin B1, Vitamin B2, Vitamin C, Vitamin D and Vitamin E). The demo creates a radar chart titled Nutritional Analysis into the worksheet based on the different vitamin content values of different brands. In the example, you are provided a sample snapshot of the chart, a drop down list that represents the chart type (Radar, RadarWithDataMarkers) and a command button labeled Create Report to create and exercise the chart based on your selection from the drop down list. You can either open the resultant excel file(s) into MS Excel or save directly to your disk to check the results.

• Filled Radar shows how to create a Filled Radar chart.

D e t a i l s

This Demo demonstrates how to create a Filled Radar chart in a worksheet.