Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Draw line graph automatically in each sheet

    Hi Experts
    I need to plot a graph in each sheet automatically ,all the columns data in each sheet same format.
    Sample attached containing two graphs needs to create in all sheets
    Attached Files Attached Files
    Last edited by farrukh; 2015-04-21 at 11:29.

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    You only provide ONE sheet. However, You need NOT do in each sheet when you can simply use ONE graph and indicate which sheet to graph. What is this for?
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  3. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Supershoe View Post
    You only provide ONE sheet. However, You need NOT do in each sheet when you can simply use ONE graph and indicate which sheet to graph. What is this for?
    Hi i have many sheets this is just an sample i give , all sheets having same format of data. On which needs to plot a graph

  4. #4
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    You could have a separate sheet and just use the data (with or without copying the data) from the desired sheet. Or, on the separate sheet, select the sheet and have a macro put the graphs on that desired sheet. Or have it automatic when the sheet is selected.and deleted when leaving sheet. OR??? The point is that you do not need to keep a graph on each sheet. Resource hog.
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  5. #5
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    I have a data in all the sheets ( different data) , need to plot a graph in each sheet based on each sheet data.

    note that every time when generate a report, new sheets auto created and the data retrieve on those sheets.I want to run a vb code to plot all the graph in each sheets.


    i am reattaching the sample added two more sheets as a sample .

    hope i understand well.
    Attached Files Attached Files
    Last edited by farrukh; 2015-04-21 at 15:25.

  6. #6
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    I don't think you understood at all. See attached for what I am talking about.

    plots-SalesAidSoftware.xlsm
    Don Guillett
    Excel Developer
    dguillett @gmail.com

  7. The Following User Says Thank You to Supershoe For This Useful Post:

    farrukh (2015-04-22)

  8. #7
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi super !
    Sorry i did not understand you...
    I see your file you did excellent job for me...
    Thank you it works for me..

  9. #8
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    Glad to help
    Don Guillett
    Excel Developer
    dguillett @gmail.com

Posting Permissions

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