Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Thank you for your answers! They definitely led me on the right track. But none of them completely got me everything I wanted, so here's what I actually ended up doing.</p> <p>The key piece of information I was missing was that I needed to put the data together in one big block, but I could still leave empty cells in it. Something like this:</p> <pre><code> Date Actual remaining Desired remaining 7/13/2009 7350 7350 7/15/2009 7100 7/21/2009 7150 7/23/2009 6600 7/27/2009 6550 8/8/2009 6525 8/16/2009 6200 11/3/2009 0 </code></pre> <p>Now I have something Excel is a little better at charting. So long as I set the chart options to "Show empty cells as: Connect data points with line," it ends up looking pretty nice. Using the above test data:</p> <p><img src="https://lh6.ggpht.com/_0WHEzSfKLTA/SmU7PEsAr3I/AAAAAAAAAC0/i5Zb00Gw0iM/Burn%20down%20chart.png" alt="Book burn down chart"></p> <p>Then I just needed my update macro to insert new rows above the last one to fill in new data whenever I want. My macro looks something like this:</p> <pre><code>' Find the last cell on the left going down. This will be the last cell ' in the "Date" column Dim left As Range Set left = Range("A1").End(xlDown) ' Move two columns to the right and select so we have the 3 final cells, ' including "Date", "Actual remaining", and "Desired remaining" Dim bottom As Range Set bottom = Range(left.Cells(1), left.Offset(0, 2)) ' Insert a new blank row, and then move up to account for it bottom.Insert (xlShiftDown) Set bottom = bottom.Offset(-1) ' We are now sitting on some blank cells very close to the end of the data, ' and are ready to paste in new values for the date and new pages remaining ' (I do this by grabbing some other cells and doing a PasteSpecial into bottom) </code></pre> <p><em>Improvement suggestions on that macro are welcome. I just fiddled with it until it worked.</em></p> <p>Now I have a pretty chart and I can nerd out all I want with my nerdy books for nerds.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I make a burn down chart in Excel?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMag Roader
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I make a burn down chart in Excel?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload