Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets

Chapter 15. Working with Charts

Create a Chart Sheet

You can use VBA to create a chart. When you create a chart, VBA creates a new Chart object. You can then set the properties such as the title, name, font, type, and style.

You can create a new chart sheet or embed a chart in a worksheet. When you create a new chart sheet, you use the Chart object directly. When you create an embedded chart, you use a ChartObjects object. See the section "Embed a Chart in a Worksheet" for more information on creating embedded charts.

To create a new chart sheet, use the Add method with the Charts object. After you create the chart, you can use a With statement to set chart properties such as chart type, the name you want to place on the chart's tab, the title of ...