Results 1 to 18 of 18

Thread: CHART Formula Change VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #15
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Here is a first simple shot for you to get your teeth into.

    I have created a class that sets up very basic charts, and a demo of same. When you have got this clear in your head we can talk about adding extra properties.

    The one thing to note at this juncture is how I use the chart type enumerated list as my data type for defining the chart. This means that when you go to set the charttype, you get intellisense, which is a big bonus IMO (you know that I love enumerated lists).
    Last edited by Bob Phillips; 06-09-2009 at 12:59 PM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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