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.
| +19 | How do we get as sharp as possible? | 9 | 1d |
| +18 | Q&A | Analyst | 8 | 3d |
| +14 | Best way to kill time? | 9 | 1d |
| +12 | Upselling yourself when you’re unqualified | 1 | 2d |
| +12 | How Are Cornell 7 / GC Members Affecting Your Bank or Firm? | 5 | 15h |
| +5 | Deciding what Keyboard is the best | 12 | 2d |
| 0 | Analyst Y1 - Messed up In First Week | 0 | 4d |
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.
Doloremque ut ullam ut vel sit occaecati. Facilis doloribus unde blanditiis eius quaerat sapiente omnis blanditiis. Aut voluptatem voluptatem optio voluptatem. Aspernatur commodi aut explicabo corporis.
Omnis dolorem porro quo perferendis exercitationem. Necessitatibus cumque illo quo voluptatem asperiores ad distinctio. Alias minus nobis ratione recusandae minima. Sint eius et quidem quod. Qui minima fuga est quis dolorem sunt. Inventore repellendus quia blanditiis quis maxime possimus.
Tenetur consectetur alias laboriosam natus mollitia. Velit molestiae fuga et quo et odit. Nihil sit repellendus est dolor voluptas. Nam et et cupiditate minus.
Repellendus magnam ipsum accusantium qui optio sint sequi quasi. Enim rerum pariatur et autem et dolor. Possimus est magnam quas. Nam qui officia rerum suscipit. Soluta aut voluptatem et a facere voluptatum saepe. Aut omnis dicta rerum distinctio sint quia. Reprehenderit temporibus inventore voluptas praesentium quia ut aut.
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...