• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Charting XML Data > Preparing the Workbook

Preparing the Workbook

One of the first actions taken in the create_charts subroutine is to store the chart parameter values from the Chart Setup worksheet. The variables l, t, w, and h are used for the Left, Top, Width and Height properties, respectively. Two more variables, plotwidth and plotheight, are used for the dimensions of the inner plot area of a chart:

With Worksheets("Chart Setup")
  ' left, top, width, height of the charts
  l = .Cells(6, 1)
  t = .Cells(7, 1)
  w = .Cells(8, 1)
  h = .Cells(9, 1)
  ' plot width and height
  plotwidth = .Cells(12, 1)
  plotheight = .Cells(13, 1)
End With


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint