Pie charts should always be displayed in descending order of sizeĪny zero values should be automatically removed from the data source.įix the last cumulative performance data to always be the last most recent month

Need to check that a chart axes actually exists before trying to modifying it incase the chart has no data.

If you select a chartobjects(2000) and there are not 2000 chart objects on the current worksheet then - does it default to 1 ? ActiveSheet.ChartObjects(1).Chart.Shapes('Arrow1')Ĭheck the colours are correct for all charts including those with a single series. There is also an additional Charts collection that contains just the chart sheets in a workbook.Īny charts that are embedded on the worksheet are not included in the Charts collection.Ĭharts embedded on a worksheet are contained on the ChartObjects collection. The macro recorder will generate code that uses the Shapes collection.Įvery workbook has a Sheets collection that contains both worksheets and chart sheets. The Shapes collection provides you with an alternative way to refer to embedded charts.

AutoScaleFont = FalseĪ chart sheet is a chart object in its own right, whereas an embedded chart is contained by a chart object.Įach chart object is a member of the Shapes collection as well as a member of the ChartObjects collection. This can be used so the size of chart items is adjusted automatically to accomadate the size of the object. This decides whether the font size changes automatically when a chart is resized.

How to plot a graph in excel vba