+ Reply to Thread
Results 1 to 1 of 1

creating and placing multiple charts based on row values in a new sheet.

  1. #1
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    creating and placing multiple charts based on row values in a new sheet.

    Hi there ,

    I'd like to create charts in an new sheet , and i have a sheet where i got over 400 lines of data.
    The data for the charts are row values ( not column values)
    Each chart should contain the header row (row1) and every 2 rows below.

    ex :
    chart 1 has rows 1 + 2 + 3
    chart 2 has rows 1 + 4 + 5
    chart 3 has rows 1 + 6 + 7

    and so on.

    I attached a file with some data and a sheet with some charts.
    Data is reduced to +/- 30 rows ( and not the full 400 rows)
    The sheet with the charts is how i'd like to have them placed in the sheet.

    I can find some code to produce several charts on the internet, or get the macro recorder and adapt the code to my needs.
    But if someone can get me in the right direction it would be appreciated.

    My biggest challenge is to put the charts evenly in a new sheet , 2 or 3 next to each other and then continue beneath the already created charts.
    If i do a manual insert of a chart , it will always put the chart in the middle of the screen , and not where i selected a cell.

    Perhaps there is a way around this ?

    Any help , links are very much appreciated.
    Thanks
    Mario
    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)

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