+ Reply to Thread
Results 1 to 2 of 2

Creating a chart with data series from several worksheets

  1. #1
    Registered User
    Join Date
    12-01-2008
    Location
    USA
    Posts
    13

    Creating a chart with data series from several worksheets

    I have a weeks worth of mesurment data taken at one minute intervals.

    Every day at midnight a new .CSV file is created by the data logging program.

    I import each CSV as a worksheet in one big workbook

    I would like to chart a these measurments for the entire week.

    So far the only way I have come up with is to copy the colums I want to make into one data series from each daily worksheet into another worksheet and creat the chart.

    Is there a way to make a chart where one Data Series can span several worksheets?

    Edit: Sample file added
    Attached Files Attached Files
    Last edited by AlphaBob; 12-02-2008 at 01:32 PM. Reason: Solved, not happy with it but solved

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,097
    No. Series can come from different sheets but data within a series must be on the same sheet.

    So building a consolidated range is the way to go.
    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)

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