Returns or sets the angle of the first pie-chart or doughnut-chart slice in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts. GapWidth Bar and Column charts: Returns or sets the space between bar or column clusters as a percentage of the bar or co...
Specifies the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie). getFiltered() Specifies if the series is filtered. Not applicable for surface charts. getFirstSliceAngle() Specifies the ...
Excel.ChartGradientStyleType | "ExtremeValue" | "Number" | "Percent" 注解 [ API 集:ExcelApi 1.9 ]gradientMidpointValue 指定区域地图图表系列的中点值。 TypeScript 复制 gradientMidpointValue: number; 属性值 number 注解 [ API 集:ExcelApi 1.9 ]gradient...
For instance, if your goal is to sell a product every day for 30 days in a row, then you might create a pie chart with 30 slices and shade a slice each day you sell the product. Best for:Showing values as percentages of a whole and viewing data elements proportionately. 6. Radar C...
Click on the Pie icon (within 2-D Pie icons). The above steps would instantly add a Pie chart on your worksheet (as shown below). While you can figure out the approximate value of each slice in the chart by looking at its size, it’s always better to add the actual values to each...
For example, if you have monthly sales data for Product X, using a pie chart would not make any sense. It is much more advisable to use a bar, column or line chart. Because of its advantages, it is very common to present data using charts. Now, the thing about charts is that they...
Finally, the poor pie digs its own grave when it allows for the level of “creativity” as displayed below: Due to aparallax effect, the slice “Pork” seems to be the largest. If you check the pie chart above you’ll see that that’s not the case. And because the chart is “expl...
Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. XlChartType Specifies the chart type. XlCheckInVersionType Specifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library...
Returns or sets the angle of the first pie-chart or doughnut-chart slice in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts. GapWidth Bar and Column charts: Returns or sets the space between bar or column clusters as a percentage of the bar or co...
Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series. Data source A stored set of "source" information used to connect to a database. A data source can include the name and location of ...