+ Reply to Thread
Results 1 to 2 of 2

Chart to show per vendor per phase per pymt per month

  1. #1
    Registered User
    Join Date
    01-06-2013
    Location
    My
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Chart to show per vendor per phase per pymt per month

    Hi all,

    I have this data -payment milestone for two vendors for each phase.
    Each Vendor may request different date/month of pymt

    Vendor A Amount Vendor B Amount Vendor A Paid On Vendor B Paid On
    Phase 1 150 130 May April
    Phase 2 200 250 June July
    Phase 3 300 300 July Aug


    Is that possible to show in a chart bar?

    Thanks!
    Last edited by seriousexcel; 04-15-2015 at 10:13 PM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Chart to show per vendor per phase per pymt per month

    see attached

    required some rearranging of the data
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 0
    Last Post: 02-04-2015, 11:38 AM
  2. [SOLVED] Need Formula that will show 'Month" for date that fall in the particular month
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-28-2014, 01:47 PM
  3. Month over Month formula to show increase or decrease in rankings for SEO
    By lindsbay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 03:03 AM
  4. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 PM
  5. Determining project phase based on specified phase time point intervals
    By ElPorko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2008, 09:46 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