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

Thread: automate charts

  1. #16
    4 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    401
    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,995
    Thanks
    157
    Thanked 781 Times in 711 Posts
    Dubdub,

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

  3. #18
    4 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    401
    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,995
    Thanks
    157
    Thanked 781 Times in 711 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
    4 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    401
    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

  6. #21
    4 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    401
    Thanks
    1
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Maudibe View Post
    My sample in post #12 does all that. You are not telling me how the data is being entered.

    Maud
    hi Maud,
    i have no intent to prolong it more, i went back to post#12 and i opened the attachment, i erased the plots and i tried to re-generate the plots but i could not.

    can you guided me how can I do that if i am using excel 2010 version. by that i mean generating all the plots in one shot not thru interactive process.

    if that not possible, i will proceed and answer those questions.
    Last edited by dubdub; 2018-07-24 at 12:00.
    TIA
    dubdub

  7. #22
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,995
    Thanks
    157
    Thanked 781 Times in 711 Posts
    dubdub,

    To assist you further, that was certainly not the response I wanted. Sorry, I cannot help you.
    Last edited by Maudibe; 2018-07-24 at 23:22.

  8. #23
    4 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    401
    Thanks
    1
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Maudibe View Post
    dubdub,

    To assist you further, that was certainly not the response I wanted. Sorry, I cannot help you.
    i sincerely do not understand what you mean by that, what i was trying to say is that post 12 you were referring to is unclear to me, and i was looking for clarification from you that could help not going further and incur additional work. apology and thanks again.
    Last edited by dubdub; 2018-07-25 at 12:55.
    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
  •