+ Reply to Thread
Results 1 to 3 of 3

Help making graph with fixed columns and varied rows

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

    Help making graph with fixed columns and varied rows

    Hello I want to make a macro that graphs A1 to A8 with respect to time and A9 to A18 with respect to time the way I have the first two graphs. I put a code in there that selects the data but it doesn't make the type of graph I need. Thanks 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: Help making graph with fixed columns and varied rows

    This will do the first set of values, A1-A8

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

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

    Re: Help making graph with fixed columns and varied rows

    Setting the xData and yData was a helpful approach to this macro. Thanks for always being so helpful Andy!

+ 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. Convert rows to columns and repeating the fixed value
    By decon6 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-21-2018, 08:50 PM
  2. Making a pivot table with fixed columns possible?
    By almst791 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2017, 07:10 AM
  3. Replies: 13
    Last Post: 10-13-2015, 04:17 AM
  4. Macro to merge and Center varied range of data in a fixed row
    By lbesley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2014, 12:39 AM
  5. Delete fixed Rows and Columns
    By brumar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2014, 02:36 PM
  6. Copying a formula with fixed rows but different columns
    By Mikethebike19 in forum Excel General
    Replies: 3
    Last Post: 11-27-2013, 06:34 AM
  7. Lookup from fixed rows and dynamic columns
    By Alexvs in forum Excel General
    Replies: 2
    Last Post: 11-09-2010, 05:39 AM

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