Results 1 to 3 of 3

Thread: How to make a CHART from a Pivoted Summary.

  1. #1
    Neophyte redwarez's Avatar
    Join Date
    Sep 2015
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Smile How to make a CHART from a Pivoted Summary.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Friends,

    Here i am attached a model of summary page of a pivoted data sheet.I am a beginner in making charts.Any can help me to make a progress chart for each contractor and no of assigned projects.


    Thanks

    Red.
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    In the attached, sheet1 has some line charts as you asked for. Sheet2 has some bar charts that I think more clearly inform the user.
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    cross posted:
    http://www.excelforum.com/excel-char...d-summary.html

    redwarez, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

    (Excelforum have the same rules but they're much harsher so it might be a good idea to add links there too.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •