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

Summary

This case study explains importing XML data, applying formulas to summarize the data, and creating multiple charts in an automated fashion. Some approaches used in this chapter, such as the coordination of chart sizing with page breaks, enable users to create impressive reports. The solution offers two paths to import the XML data, depending on the version of Excel being used. The MSXML Parser is key to sophisticated XML processing with older versions of Excel.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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