Figured I'd pose it to all you Excel wizards.
I have this excel sheet where I enter data row by row, maybe a dozen or two rows a day. There is an associated chart displaying the data.
Right now I have to re-format the axes whenever I add more data to make everything fit nice and snugly. I've tried several times to make it so the x-axis of the chart expands automatically to include the newly entered data, but so far no dice.
I'm sure this can be done with VBA, but even better if without. Thanks.
| +73 | Uchicago is paradise | 14 | 3d |
| +59 | BofA VP killed in random NYC stabbing | 36 | 1d |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 1d |
| +13 | POLL: Optimistic or Pessimistic? | 9 | 4d |
| +12 | At what salary can you start calling it “fi-NANCE” | 3 | 1d |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 3d |
| +5 | Lindsay Clansey | 3 | 14h |
| +1 | Someone just coined "the view" | 3 | 3d |
| 0 | What Are the Best Ways to Keep Office Carpets Clean? | 1 | 1d |
| 0 | Abstention | 0 | 18h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Try inserting rows when you enter the data
This sounds good. Did this method work?
graph named ranges. makethe named ranges dynamic. http://www.excel-easy.com/examples/dynamic-named-range.html
Better yet, convert the data to a Table, this will automatically factor in new cells when applying the table name as the data points in a chart, highlight the range of data you want and click INSERT tab, and go to table. This automatically generates names for your headers, and you can name the table under the design feature.
Ullam dolorem alias rerum eum. Qui molestiae qui autem a esse autem sunt. Quia dolor tempora sint eum reprehenderit ipsam. Iste quisquam omnis sit pariatur. Aspernatur autem minima labore sit enim assumenda.
Aut qui voluptas velit molestiae aliquid harum qui nemo. Eum omnis cumque voluptatem tenetur beatae suscipit et. Rem quis qui repellendus quia ipsum quaerat. Et nesciunt id et facilis id possimus ab.
Error vero doloremque minus non officia. Nemo dolor magni rem corporis atque eos.
In sequi esse neque autem eaque. Voluptatem facere necessitatibus perferendis sint beatae dolor voluptatem deserunt. Nam inventore commodi distinctio illum ipsam aut error voluptas. Quia similique deserunt quasi vitae. Quo dolores corrupti est. Sit voluptatem culpa est minima iusto voluptas saepe. Quidem temporibus expedita eum qui aut vero.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...