Results 1 to 3 of 3

need to group by date and chart each day

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    NC
    MS-Off Ver
    Excel 2011 - Macintosh
    Posts
    21

    need to group by date and chart each day

    I'm not having luck with getting a chart to do what I want and would appreciate any help.

    The attached workbook file has a sample of the data and the formula that allows a date range to be entered and then totals the values for that range. This is great for checking specific days.

    What I want is a chart that totals each days values for all days available. This needs to be done without entering in a date range manually. Would like to do something like that looks like this . . .
    desired chart.gif


    Thanks for any suggestions.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 10-23-2014, 09:57 AM
  2. [SOLVED] Can't group dates on my pivot chart
    By David_Patsy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2014, 12:26 AM
  3. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  4. [SOLVED] find missing date on every group date list based on range and criteria
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2013, 01:26 AM
  5. Excel 2007 : Using VBA to group a pie chart and a textbox
    By deadlyduck in forum Excel General
    Replies: 2
    Last Post: 11-10-2009, 02:00 PM
  6. Group & Stacked Chart
    By mariab in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-03-2006, 11:27 AM
  7. [SOLVED] How do i group together different charts into a single chart in e.
    By Mukund in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-14-2005, 11:06 AM

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