+ Reply to Thread
Results 1 to 5 of 5

Efffective Chart Presentation

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    95

    Exclamation Efffective Chart Presentation

    I need help in presenting the numbers in the worksheet attached. I need to be able to show in the graph the number of accounts covered which are below each column header (time) and the number of accounts is the accounts that they need to cover. Whats the most effective way of presenting my data that will allow them to understand how the accoutns are covered every hour with the total # of accounts included.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Efffective Chart Presentation

    Hello
    Take a look at the attached reply. It might give you a few ideas. It's a standard Bar Graph with an XY Scatter on the Secondary axis to provide the target line for the # of Accounts.

    Hope this helps.
    DBY
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-02-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    95

    Re: Efffective Chart Presentation

    Quote Originally Posted by DBY View Post
    Hello
    Take a look at the attached reply. It might give you a few ideas. It's a standard Bar Graph with an XY Scatter on the Secondary axis to provide the target line for the # of Accounts.

    Hope this helps.
    DBY
    Thank you. But is there a way where I can show that they are almost near the target?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,203

    Re: Efffective Chart Presentation

    How about a pie chart?
    Attached Files Attached Files
    Ben Van Johnson

  5. #5
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Efffective Chart Presentation

    But is there a way where I can show that they are almost near the target?
    I'm assuming from this that you perhaps wanted to show the accumulative count for 10am - 2pm. Ben's solution above is one way of getting a percentage breakdown against the target. Alternatively, you could use something like a stacked bar, see attached image.

    Stacked Bar.jpg

+ 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. [SOLVED] Chart presentation in excel
    By silambarasan.J in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-10-2015, 05:55 AM
  2. 3d Surface Chart - How to Add Vertical lines for better presentation
    By Steveapa in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-09-2015, 09:15 AM
  3. Excel chart in powerpoint presentation
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2014, 06:53 AM
  4. Need chart for presentation
    By mubeenff in forum Excel General
    Replies: 1
    Last Post: 05-23-2014, 05:03 PM
  5. Help need for a presentation how do i chart this information
    By speedrater in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-15-2012, 11:52 PM
  6. Update linked Excel chart in PowerPoint Presentation
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2012, 03:20 AM
  7. Excel Chart to Presentation Slide
    By angela901 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2011, 09:19 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