+ Reply to Thread
Results 1 to 2 of 2

How to automate graphing groups of data that have the same condition number in a column?

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    30

    How to automate graphing groups of data that have the same condition number in a column?

    Hello I can manually graph the data that corresponds with the data and time but how could I automatically do this with a command button macro?
    Ive attached an example of how I'm trying to get the graphs to come out. I've tried if statements and do until statements but I keep getting an error. Thank you for your help
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to automate graphing groups of data that have the same condition number in a colum

    Try this,

    Please Login or Register  to view this content.
    You might want to include markers as those charts with only 1 time period do not display well.
    There may be other formatting you want to apply, in which the macro recorder should help generate code you can slot into this code
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 01-18-2016, 11:13 PM
  2. Automate batch graphing of 200 individual files YIKES!!!
    By pbd3mon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-01-2015, 09:30 PM
  3. Automate graphing multiple x ranges from different groups (>100 graphs)
    By plumberef in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-20-2015, 07:44 AM
  4. [SOLVED] trying to count the number of groups of like data in a column
    By Rob69mfj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2014, 04:03 PM
  5. [SOLVED] Display data in different column based on number condition
    By sarinky in forum Excel General
    Replies: 4
    Last Post: 11-06-2012, 05:39 AM
  6. Replies: 6
    Last Post: 06-03-2010, 04:25 AM
  7. [SOLVED] Graphing only data that meets a condition
    By Heidi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-19-2006, 04:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1