Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2003

    Question Unanswered: Best practice for crunching numbers and charting

    What is the best way to transform a recordset into a nice functional graph?

    I've got the recordsets but I need to 'crunch' the data before I chart it. Excel's Pivot Table is a great tool for crunching the data. Access has a Transform function to do it. ChartFX does it but I don't have the VB version.

    Here are the requirements for what I'm trying to get accomplished.

    1) Ability to 'crunch' the data into correct format.

    2) Graphing tool needs to be functional enough to allow multiple y-axis on the same chart. (E.G. Yield % charted as a line on y-Axis1 and # of Units tested charted as a bar on y-Axis2)

    3) Has to be a VB solution.

    I'm curious what ideas/experience this forum can provide as the starting point for this project.

    I've got a very simple Excel file to illustrate what I'm trying to get accomplished...unfortunately I can't upload with this post (incompatible format), but I'll email if anybody is interested.

    Thanks for your help,

    Last edited by alex8675; 12-30-03 at 17:20.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts