+ Reply to Thread
Results 1 to 5 of 5

Monthly-Sum Graph

  1. #1
    Registered User
    Join Date
    12-11-2014
    Location
    ISL
    MS-Off Ver
    2007
    Posts
    3

    Thumbs up Monthly-Sum Graph

    How can I turn the values [from the left] to this kind of monthly-sum graph as the preview graph shows [from the right]
    Thanks in advance
    a.jpg
    Last edited by dlnes; 12-11-2014 at 06:30 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Monthly-Sum Graph

    Do you specifically want the dotted lines up to the total money amount? Attached is a pivot chart. Would that serve your purposes?
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    12-11-2014
    Location
    ISL
    MS-Off Ver
    2007
    Posts
    3

    Re: Monthly-Sum Graph

    Thank you first of all!
    Yes, Your attachment is exactly as I wish it to be.
    Now, How to make the chart updateable by the Date&Amt(A:A & B:B) columns?

    Thanks

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Monthly-Sum Graph

    You can select A:B when creating the pivot chart (Insert>Pivot> Chart)
    Then group the date by month and year

    Pivot charts unfortunately need to be refreshed when you add data. So after adding raw data, right click on the pivot data and "refresh"

  5. #5
    Registered User
    Join Date
    12-11-2014
    Location
    ISL
    MS-Off Ver
    2007
    Posts
    3

    Re: Monthly-Sum Graph

    It helped!
    I give you rep and I thank you!

+ 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. Create graph monthly and yearly
    By Kevalin O in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2013, 07:49 AM
  2. Automatic graph using monthly data
    By bruff1987 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 02:02 PM
  3. Monthly Spreadsheet with Graph
    By trsisko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2012, 12:05 PM
  4. Replies: 1
    Last Post: 02-07-2012, 04:43 AM
  5. Replies: 4
    Last Post: 07-07-2011, 04:58 AM

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