Results 1 to 4 of 4

How to make chart

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to make chart

    Hi,
    I am a DBA actualy and this is the first time m boss has asked me to play with the MS Excel to draw some charts for the System Service Requests (SSRs) we recrieve from our customers. I want to draw a char you can see in the image i am uploadin in file "Chart.png". Data is available in the File "Forum.xls". IS there anyone who can draw this for me and also teach me how to do this. I have spent many many hours but couldnot find.
    In Excel file:
    Months: Month for which we receive SSRs
    Number of SSRs: Total nmber of SSRs for each month.
    Early: Number of SSRs which finished before its scheduled time
    Hit: Number of SSRs closed within its scheduled time
    Misses: Number of SSRs closed after the scheduled time
    No. of Reschedules: Total number of times of reschedules for any SSR.

    So -> Early+Hit+Misses = Total number of SSRs
    Reschedules are independent of all other values and should be shown as a line in this bar chart.

    I would really appreciate if some one could help me and tell me how to daw this type of hybrid chart.
    Thanks

    Salman
    Attached Images Attached Images
    Attached Files Attached Files

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