Updates
2016 January | Funnel Chart Type - New chart type that can be used to represent different stages in a process showing progressively decreasing proportions. |
2016 | 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 | |
2013 | Chart Tools Layout Tab was removed. |
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 |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext