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.
| +23 | Funny Things to Say to Interns | 6 | 2d |
| +21 | SpaceX IPO - what are your thoughts | 3 | 4h |
| +18 | Should I use Claude or chatgpt? | 8 | 1h |
| +17 | London's future as a financial centre | 18 | 9h |
| +16 | How did you meet your significant other/partner? | 12 | 19h |
| +9 | Top 5 Artificial Intelligence Software Development Companies | 0 | 2h |
| +9 | Study in Europe and How to Pay Tuition Fees in Europe | 0 | 3h |
| +7 | E ink/electronic notepads | 3 | 2d |
| +7 | Ferrari Luce | 7 | 1d |
| +6 | Test post will be deleted automatically. | 9 | 4h |
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.
Aut quaerat voluptatibus vitae. Sed officiis magni hic voluptas. Quia harum consequuntur ea officia est similique voluptatibus. Dignissimos odio nulla omnis provident.
Eum nihil voluptatem ad rerum odit ut. Est temporibus blanditiis aut ducimus ea.
Ut et eaque sit aut esse. Et et itaque veniam delectus voluptas asperiores corporis maxime. Recusandae quia voluptas rerum quia dolorem commodi rem. Ut facilis maiores sunt et eaque. Molestias architecto blanditiis magni ipsam dicta consequatur sunt. Aliquam ut provident ipsa nihil eaque eos. In molestiae nihil quia.
Repudiandae ipsa rerum beatae quia in. Voluptate et natus et assumenda sunt. Voluptatem nihil rerum quisquam ex dolorem. Quisquam maiores laborum consequatur vitae atque dolorem a. Cupiditate adipisci quo aut aliquid dolor aspernatur consequatur. Eligendi laboriosam minima id beatae.
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...