+ Reply to Thread
Results 1 to 5 of 5

Historical Data Chart

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Historical Data Chart

    I'm trying to create a chart that will sum up the data as things are approved based on their approval dates. There should be two columns, pending and approved and they should create a chart like the one in the attached excel file.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Historical Data Chart

    There is no attached file.

    BSB

  3. #3
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Historical Data Chart

    Here is the attached file.
    Attached Files Attached Files

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Historical Data Chart

    With such a small data sample it's not massively easy to fathom exactly what you need.
    Two examples in the attached. Hopefully one of them will suit your needs or at the very least point you in the right direction.

    Hope that helps.

    BSB
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Re: Historical Data Chart

    Thanks,that is exactly what I needed. I didn't know you could do that, but it makes sense.

+ 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. Historical Data
    By Mythras in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2014, 05:14 PM
  2. [SOLVED] Historical Data
    By nickm84 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2013, 02:38 PM
  3. Historical 2d data
    By CDNSimpson in forum Excel General
    Replies: 2
    Last Post: 01-09-2011, 05:37 AM
  4. Easiest way to Copy/Paste data from Recurring Form to an Historical Data Sheet
    By willy91785 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-15-2010, 02:11 PM
  5. Sort historical data
    By changy in forum Excel General
    Replies: 4
    Last Post: 01-14-2010, 06:09 AM
  6. Pareto Chart with hyperlink to Historical change
    By doc1388 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-19-2009, 10:35 PM
  7. Auto Update 7 Day Historical Chart
    By Engineers2008 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-12-2009, 05:39 PM
  8. Web query and historical data
    By PaulJohns in forum Excel General
    Replies: 2
    Last Post: 12-22-2008, 05:49 PM

Tags for this Thread

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