Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-04-2019, 01:06 PM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default Burn up for my time line

Hiya. I have a spreadsheet with the columns

ID (unique)
Title
Done (yes/no)
Done on (date - empty if Done is no)

This sheet has x number of rows.



I want a burn down that will allow me to show progress over time to the goal of x being done by EOY (12/31/2019) with a data point for each month.

Can anyone tell me how to do this as I am quite new to Excel shenanigans of this sort. Thanks!
Reply With Quote
  #2  
Old 03-05-2019, 12:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample sheet (no pics please) with some data and expected results. Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 03-05-2019, 06:12 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default

I would LOVE to but cannot see how to attach a file.
Reply With Quote
  #4  
Old 03-05-2019, 07:21 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default

Let's see if I figured my drive right. Worst case, I have accidentally shared my grocery list.

Last edited by Pecoflyer; 03-06-2019 at 12:23 AM. Reason: Link removed - File added later
Reply With Quote
  #5  
Old 03-05-2019, 07:23 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default

So if you can get to the workbook, you will see data. ANd on one sheet is a pivot table and chart. My chart is getting close. I want each point to be the total as of that month. So Jan's point would be 5. Feb's point would be 34. I could then increase the y-axis to go to my fixed total and just draw a fixed line there.

Does that make sense?

Thanks
Reply With Quote
  #6  
Old 03-05-2019, 09:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,383
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

To attach a file click Quick Reply - go advanced - follow the wizard ( external links are notoriously unsafe and not all members can/will access them)


And BTW we have a nice FAQ feature where lots of things are explained...
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #7  
Old 03-05-2019, 09:29 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default

here it is
Attached Files
File Type: xlsm TestCaseStatus.xlsm (28.2 KB, 9 views)
Reply With Quote
  #8  
Old 03-05-2019, 09:39 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default

Well now I have learned something new. I would not want to click an external link either! Thanks for the info.
Reply With Quote
  #9  
Old 03-06-2019, 06:19 AM
vthomeschoolmom vthomeschoolmom is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2012
Posts: 23
vthomeschoolmom is on a distinguished road
Default

And I was moronic and posted a macro enabled workbook which no one will open. Erg.
Attached Files
File Type: xlsx TestCaseStatus.xlsx (28.2 KB, 1 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time CPSmith Excel 1 03-26-2016 02:48 AM
Control Time Calculaiton depending on whether line is running or not. rdperry11 Excel 4 02-24-2015 09:35 PM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Highlight one line at a time billy589 PowerPoint 1 10-04-2010 02:33 PM
burn cd of word cuzzx Word 5 04-29-2010 11:02 AM


All times are GMT -7. The time now is 05:46 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft