Microsoft Access
  Home arrow Microsoft Access arrow Page 5 - Creating Data Access Pages with Charts usi...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Silverlight  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
ASP Web Hosting  
ASP.NET Web Hosting 
Windows Web Hosting
 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

Creating Data Access Pages with Charts using Office Web Components
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 4
    2007-01-10

    Table of Contents:
  • Creating Data Access Pages with Charts using Office Web Components
  • Monthly temperature chart for Princeton
  • Monthly temperature chart for Princeton continued
  • Creating an X-Y graph
  • Creating a Pie Chart

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Creating Data Access Pages with Charts using Office Web Components - Creating a Pie Chart


    (Page 5 of 5 )

    The next picture shows the final few steps of creating the Pie chart. The source for this data is the Portfolio table. The type of chart chosen is the Pie chart type. When you make these selections, the design view of the data access page changes as shown.

    Now right click on the OWC and bring up the field List. Drag and drop the Stock to the Drop Category... place holder and the Percent field list to just below the Drop Filter Fields Here place holder as shown in the next picture.

    .

    This page may also be saved to the same default directory as before.

    Summary

    Creating data access pages which display charts of various types is quite easy. The pages are interactive for licensed users. The steps in charting are fairly straightforward except that the drag and drop operation may sometimes lead to confusion. The online help is excellent as it is very useful to clarify most of your problems. The Microsoft Office Web site is another location where you can find help. The tutorial considered data in the local mdb file. It is just as easy to chart data on a connected data source.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

       · If you have read two of my articles at this site on creating chart with MSChart...
     

    MICROSOFT ACCESS ARTICLES

    - Converting a MySQL Database to an Excel Work...
    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
    Stay green...Green IT