Microsoft Office Forums Burn up for my time line

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2019, 01:06 PM
vthomeschoolmom vthomeschoolmom is offline Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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 Burn up for my time line Windows 7 64bit Burn up for my time line Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,396
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 Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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 Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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 Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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 Burn up for my time line Windows 7 64bit Burn up for my time line Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,396
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 Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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 Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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 Burn up for my time line Windows 7 32bit Burn up for my time line Office 2010 32bit
Novice
Burn up for my time line
 
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
Burn up for my time line Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time CPSmith Excel 1 03-26-2016 02:48 AM
Burn up for my time line 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
Burn up for my time line 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 01:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft