+ Reply to Thread
Results 1 to 2 of 2

Multiple Charts from a lot of data

Hybrid View

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Multiple Charts from a lot of data

    Hello,

    I already posted this once in the general thread but I think I might get more answers here. I'm in dire need of help with the following issue. I have a date set that dates back to 1911 and need to create charts for every change in year. Can someone please help?

    Note I need the X scale (Julian day 91 to 253) and Y scale (just needs to be consistant for all the charts) to be the same for all the charts.

    I've attached the data set and a sample graph but the Y scale isn't correct on the graph becuase one of the data sets in the lists will hit 1160.


    Thank You!

    Data.xlsx

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,388

    Re: Multiple Charts from a lot of data

    Hi,

    You need to do a simple pivot chart where the year is the filter. Change the year in the filter and it will do each chart one at a time. You could copy and paste the answer for each year into some other sheet or program. See attached for your data back with the answer.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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