+ Reply to Thread
Results 1 to 2 of 2

help creating a table with a dynamic pie chart based on date

  1. #1
    Registered User
    Join Date
    04-02-2020
    Location
    england
    MS-Off Ver
    2013
    Posts
    1

    help creating a table with a dynamic pie chart based on date

    hi everyone, this is my first post. I know a little bit about excel but my knowledge is limitted, so any help would be appreciated.

    I am trying to make a booking sheet, that collects time in and time out of bookings and returns the duration of the booking. I will then need a pie chart that shows a total of this for that day, and then retruns how much time is left for that day. To provide some context this is for a car garage and there are 16 hours in the day. So the pie chart needs to return how much time is left from the bookings to arrange new bookings.

    so far i have managed to do this but it only works for one day, i want to be able to filter the row date, so the pie chart is dynamic based on the date selected. as you will see from the attached document i have got so far, but i am now stuck. This is so i can add multiple dates to the pie chart.

    would anyone be so kind to help me with this please.

    many thanks
    Seth.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2003, 2010, 2016 (Windows)
    Posts
    4,634

    Re: help creating a table with a dynamic pie chart based on date

    Use a conditional sum formula - SUMIF, as in the attached. Enter the date of interest into cell H3, and the chart will update. I also changed your formula in D to avoid errors that would affect the SUMIF formula.
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Creating a Dynamic Chart Based on Variables
    By nohmis in forum Excel General
    Replies: 4
    Last Post: 01-03-2019, 09:07 PM
  2. Problems creating a bar or column chart based on dynamic offset ranges
    By chrisk67 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-01-2016, 03:23 PM
  3. Creating a dynamic chart accoding to table
    By R3DAlert in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2016, 01:01 PM
  4. Creating dynamic userform based on several file names and creating chart overlays
    By Thorn23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2014, 12:09 PM
  5. Replies: 9
    Last Post: 02-26-2014, 04:17 PM
  6. Replies: 7
    Last Post: 11-24-2010, 05:35 AM
  7. Creating chart w/ formula based dynamic axes
    By mmorri4 in forum Excel General
    Replies: 3
    Last Post: 05-25-2010, 11:37 AM

Tags for this Thread

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