Updates

2019Funnel - New chart type that can be used to represent different stages in a process showing progressively decreasing proportions.
20166 new chart types - microsoft.com/en-us/microsoft-365/blog/2015/07/02/introducing-new-and-modern-chart-types-now-available-in-office-2016-preview/
 Box Whisker - New chart type
 Histogram - New chart type
 Pareto - New chart type
 SunBurst - New chart type
 Treemap - New chart type
 Waterfall - New chart type
 Mini Toolbar - This has been changed when you have a chart selected and now includes - Fill, Outline, Chart Elements
 VBA - FullSeriesCollection Property
oChart.FullSeriesCollection(1)
This allows you to iterate over the full set of series objects including those that are not visible or have been filtered out. The SeriesCollection only contains the visible series objects of a chart
 Exploded Pie charts - support.microsoft.com/en-us/office/explode-or-expand-a-pie-chart-63284b67-22ea-4960-ab1e-0a3895af68ce
2013Chart Tools Layout Tab was removed.
 The Insert Chart and Change Chart Type dialog boxes do not show the Cone, Cylinder and Pyramid chart types.
 Any 3D Bar or Column chart types can have their shape changed to cone, cylinder or pyramid. This option can be found in the Format Data Series task pane.
 The "Save as Template" button has beem removed from the ribbon. To save a chart as a template, right-click the chart, and then click Save as Template.
2010Double click reinstated to display the Format dialog box.
 Pattern Fills reinstated
 Draft Mode - Chart Tools Design Tab - new Draft Mode button. This allows charts to be drawn with very basic formatting, to speed up screen refreshing. Added in the beta version but removed prior to the final release.
 Sparklines added
 Macro recording reinstated to record anything relating to charts and pictures
 VBA - CHARTVIEW OBJECT
The ChartView object applies only to chart sheets. The ChartView object is one of the objects that can be returned by the SheetViews collection, similar to the Sheets collection.
objChartView = ActiveWindow.SheetViews.Item(1).Sheet
2007Chart Windows was removed
 Chart Wizard removed
 Chart Types - The 18 cylinder, cone and pyramid chart types have been moved to column and bar respectively
 Data Labels cannot show legend keys
 VBA - ChartGroups have been depreciated
 Microsoft Graph removed
2003Chart Toolbar
 Chart Menu
 Chart Wizard
 Chart Options
 Chart Types - Changing
 Chart Types - Custom

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext