+ Reply to Thread
Results 1 to 2 of 2

Makro to create diagrams from a table with 89 columns

  1. #1
    Registered User
    Join Date
    01-08-2010
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Makro to create diagrams from a table with 89 columns

    Dear All

    I have a table with data from a wastewater treatment plant. The table contains 89 columns. Column A is the day/date. The rest of the columns are measurements parameters from Column B till Column CH.

    I would like to create a makro which create an x-y dot plot with X-axis always Column A (date) and the Y-axis the other parameters. In the end I should have 88 plots where each plot shows me the graph of one parameters vs. the date.

    Unfortunately, I am not able to tell VBA to move forward by one column. I can only record the creation of one plot but then the makro will always use the same column and not move on! Can anybody help me by providing the code for such a makro? Thank you very much in advance!

  2. #2
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: Makro to create diagrams from a table with 89 columns

    Can you post a workbook with some dummy data in it? Do you need 88 plots or could you have 1 with a drop down allowing you to select each parameter to be plotted?
    Please consider adding a * if I helped.

+ 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. how do I create this table, divide row into 2 columns??
    By flordai2001 in forum Excel General
    Replies: 5
    Last Post: 07-14-2014, 07:39 PM
  2. how can i create piper and stiff diagrams in excel sheet?
    By medo82006 in forum Excel General
    Replies: 2
    Last Post: 05-26-2013, 07:02 PM
  3. Making Vector Diagrams/ Line diagrams
    By jaaj in forum Excel General
    Replies: 1
    Last Post: 09-07-2009, 06:01 PM
  4. VBA/Excel - how do I create a user-defined function out of a makro?
    By marasmussen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2007, 08:21 PM
  5. [SOLVED] Can I get additional diagrams for flow diagrams
    By alan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2006, 08:45 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