April 2006
Beginner
1114 pages
98h 16m
English
Content preview from Programming Excel with VBA and .NET
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Choose Chart Type
The ChartType property controls what type of chart to plot, but not all chart types are compatible with the data you may want to chart. For example, the xlStockOHLC chart plotted in the preceding section requires four series in a particular order: Open, High, Low, and Close prices. To try out different chart types:
Select the data to chart, then choose Insert → Chart to start the Chart Wizard.
Select a chart type and subtype then click the button below the subtype list to preview the result, as shown in Figure 16-4.
If the selected data doesn’t match what is required by the chart type, the preview displays a message explaining the problem.
Figure 16-4. Trying out different chart types
Again, you can record your actions to find out the xlChartType constant for the chart type you want.
The DemoChartTypes procedure in the sample workbook cycles through all of the available ChartType settings, pausing after each. You can use that procedure to choose from the many chart types and find the corresponding xlChartType constant. That procedure is too long to reproduce in print, so here is an abridged version:
Sub DemoChartTypes( ) Dim chrt As Chart, secs As Double secs = 1 / 100000 Set chrt = Charts("Demo Chart Types") chrt.Activate chrt.ChartType = xl3DAreaStacked chrt.ChartTitle.Caption = "ChartType: xl3DAreaStacked" chrt.Refresh Application.Wait Now + secs ' Repeat for each ...Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.