Updates
2019 | Funnel - New chart type that can be used to represent different stages in a process showing progressively decreasing proportions. |
2016 | 6 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 | |
2013 | Chart 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. | |
2010 | Double 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 | |
2007 | Chart 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 | |
2003 | Chart 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