+ Reply to Thread
Results 1 to 9 of 9

create multiple x y charts, one for each column with the same x axis using excel-vba

Hybrid View

istvan60 create multiple x y charts,... 02-02-2015, 05:40 PM
Brendan_Floyde Re: create multiple x y... 02-02-2015, 06:50 PM
istvan60 Re: create multiple x y... 02-03-2015, 03:31 AM
Brendan_Floyde Re: create multiple x y... 02-03-2015, 07:15 AM
istvan60 Re: create multiple x y... 02-03-2015, 12:39 PM
istvan60 Re: create multiple x y... 02-03-2015, 12:59 PM
Brendan_Floyde Re: create multiple x y... 02-03-2015, 06:35 PM
istvan60 Re: create multiple x y... 02-03-2015, 06:40 PM
Brendan_Floyde Re: create multiple x y... 02-03-2015, 06:46 PM
  1. #1
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: create multiple x y charts, one for each column with the same x axis using excel-vba

    If you just run the plot macro in the file i posted what happens exactly? i.e. just download, open, run the macro.
    Please consider adding a * if I helped.

  2. #2
    Registered User
    Join Date
    12-07-2013
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: create multiple x y charts, one for each column with the same x axis using excel-vba

    On that file it runs perfectly, I do not have any idea why it won't work in the original document. It says: Location of object chart failed.

    This is how the graphs looked. In the next reply I have added the original file that I used and additional comments.

    screen.png
    Last edited by istvan60; 02-03-2015 at 01:01 PM.

  3. #3
    Registered User
    Join Date
    12-07-2013
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2013
    Posts
    9

    Re: create multiple x y charts, one for each column with the same x axis using excel-vba

    On that file it runs perfectly, I do not have any idea why it won't work in the original document. It says: Location of object chart failed or, Runtime error 1004, method ' Range of object'_Global failed

    I have attached the original file, and it would be more than perfect if it would plot the graphs referring to the same worksheet on one new wsheet.

    Attachment 374771

    Thank you very-very much for your efforts so far.
    Attached Files Attached Files

+ 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 plot multiple x-axis series in excel charts
    By bdorr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-22-2018, 08:52 PM
  2. Replies: 3
    Last Post: 10-16-2014, 02:01 PM
  3. Replies: 3
    Last Post: 02-05-2012, 10:04 AM
  4. Replies: 0
    Last Post: 07-28-2011, 02:11 AM
  5. [SOLVED] Create and customize axis on all sides of charts
    By Nicholas in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-18-2006, 09:25 AM

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