Results 1 to 6 of 6

Charting Non-Contiguous Data Ranges

Threaded View

  1. #5
    Registered User
    Join Date
    02-08-2009
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Charting Non-Contiguous Data Ranges

    yea.. very much what i was looking for, (although reversed) but in order to get that chart, i guess I will need to re-organize how the data is entered.. one reading per row instead of 5. Sort of how you did.

    This is something I am considering. However it leads to another problem I would have to figgure out.

    If i use date in column A, time in column B, and reading in column C, I need to feed the frequency data (and even that chart) a dynamic range that would include only readings who's dates are current date minus 7 days, or current date minus 30 days.
    Last edited by Aakanaar; 02-09-2009 at 10:50 PM.

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