Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20

Thread: automate charts

  1. #16
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    397
    Thanks
    1
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Maudibe View Post
    Hi dubdub,

    Can you please walk me through a scenario of what data you are staring with, what data is being added by the user, and based on the added data, what you want to occur along with the end result?

    Thanks,
    Maud
    hi Maud,
    Assume the starting data is what I included in the attachment at the beginning of the post, attached, assume also I want to automate the creation of the chart types depicted beside that data, and any time a new data added, it will follow the same structure; and I will use the macro to re-generate the same type of charts again for the old data and create new charts for the new data.

    i have added a new d4(dep) and Pup (Serv) as an additional data.

    please let me know if you have other suggestion.
    Attached Files Attached Files
    TIA
    dubdub

  2. #17
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,982
    Thanks
    156
    Thanked 774 Times in 705 Posts
    Dubdub,

    Is it that you want to copy/paste a whole block of data, in the above case, D4-Pup?

  3. #18
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    397
    Thanks
    1
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Maudibe View Post
    Dubdub,

    Is it that you want to copy/paste a whole block of data, in the above case, D4-Pup?
    hi Maud,

    no, the data is a sample, and it has a frequent update to the existing data and chances for addition, and what i want is to automate the creation of those charts at any time at any size of data.
    TIA
    dubdub

  4. #19
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,982
    Thanks
    156
    Thanked 774 Times in 705 Posts
    Sorry dubdub, I cannot help you because I just don't understand what you want. Maybe someone else might have something to offer.

  5. #20
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    397
    Thanks
    1
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Maudibe View Post
    Sorry dubdub, I cannot help you because I just don't understand what you want. Maybe someone else might have something to offer.
    thanks Maud for the effort,

    i will try one more time, because if you did not understand it is my fault,

    assume the data i have in the attachment, and i want to create charts to represent it.

    The chart template i want to use is the one i have in the attachment.

    For any change in columns a or b a separate/new chart will be created, for the sample data i attached that means 5 charts are needed.

    note, the chart title will come from columns a&b.
    TIA
    dubdub

Page 2 of 2 FirstFirst 12

Tags for this 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
  •