Results 1 to 3 of 3

Thread: Chart Assistance required please

  1. #1

    Chart Assistance required please

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

    Hi there,
    I hope you can assist me with the following query.
    I want to use Excel to graphically illustrate to my bosses how a typical work day is sent.
    My current situation: A quick background to understand my request.
    Our boss owns two companies & I have a handful of tasks I need to complete daily for each.
    Both companies are very demanding & I need a way to capture how my time is spent.
    The easiest way to get my point across would be a % pie chart of my time.

    Essentially I need two pie charts, one showing overall company time.
    The second pie chart will need to show a ďtypeĒ breakdown of what the above % consist of.
    Support, Training, Implementation, Projects etc.

    I imaged the I need flowing & I am just not able to get it right the pie chart right
    Below is a breakdown of the columns I envision I need.

    Time Start Time End Company Task Type Task Description

    As I get tasks I want to assign it to the appropriate company, enter the task type & description.

    I need pie chart one to add all company 1 & company 2 events to illustrate what % of my time is spent on which company.
    Letís say pie chart 1 showed overall I spent 40% of my time on Company A.
    I now want pie chart 2 to show that Company Aís time can now further be analysed & show how much of that time is spent on training, support, projects etc.

    I would greatly appreciate your assistance.

    Kind Regards

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    Hi there, and welcome to the forum. Do you happen to have a table with data in it? If you gave us some data, then we could start you on the path to charting it.

    Personally I'm a bigger fan of bar charts than pie charts, but we can help you build either.

    You can upload a workbook by going into the Advanced options.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    You can also use line chart to display how your time is spent.Allocation of time of period of days will be better visible in line chart is my view

Tags for this Thread

Posting Permissions

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