CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. August 28th, 2001, 08:02 AM #1
    Carol Torres
    Carol Torres is offline Junior Member
    Join Date
    Aug 2001
    Location
    PR
    Posts
    1

    Automating Chart Creation on Excel

    Hi I'm a beginner in VB, and I'm facing the following issue: I have a program that exports the data I need to Excel (version 2002 - XP), and I need that once Excel recognizes that new data have been posted on a sheet, to automatically create a chart. Can anybody give me some suggestions about how can I do that?

    Thanks in advanced for your help.

    Reply With Quote Reply With Quote
  2. August 28th, 2001, 08:28 AM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: Automating Chart Creation on Excel

    Create the chart in Excel using Chart wizard for the range where you will post your data. Now enter data (using VB) to the Excel sheet and the chart is automatically there

    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
  3. September 3rd, 2001, 05:23 AM #3
    Bennie Veenstra
    Bennie Veenstra is offline Junior Member
    Join Date
    Sep 2001
    Location
    The Netherlands
    Posts
    1

    Re: Automating Chart Creation on Excel

    I have an application that uses excel and creates a chart automaticly. However I can't get it done to insert a pagebreak between two charts.
    Who can supply me with the code to insert a pagebreak in excle using Visual Basic 6.0 SP5?

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured