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

Chapter 14. Charting XML Data > Creating the Charts

Creating the Charts

Now the activity returns to the Charts worksheet. From wherever the code is in the loop's iterations, the chart needs to be inserted in the vertical position that coordinates with how the rows were previously resized. When this is the first chart, the Top property is simply 1; however, for all charts from number two to the end, the Top property is calculated.

Sheets("Charts").Activate
' need to preserve t as incremental value, so use
' chart_top variable for the actual top value of each chart
If chart_count = 1 Then
  chart_top = 1
Else
  chart_top = t * chart_count - t
End If


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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