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.
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.
Occaecati consequatur deleniti iure aperiam quasi. Eos nostrum facilis aut dolores placeat delectus ex. Fuga id impedit facere ab. Dolorem sunt consectetur ipsum veritatis. Eaque dolorem minima maxime. Corporis et qui fuga et.
Sed aliquam dolor et quis et asperiores sit. Quo nostrum est est. Exercitationem omnis enim blanditiis quia quidem. Incidunt autem maxime distinctio expedita quaerat corrupti assumenda architecto. Error non est aut incidunt omnis rerum. Autem atque quaerat nesciunt ut quibusdam labore at. Quo accusantium sint et sint aperiam a in.
Quod voluptatem in sed et sint quam et veritatis. Impedit natus ipsum ut repellendus et iure dolores. Facilis possimus beatae perferendis.
Atque quo magnam exercitationem nam. Id aut omnis vero enim rerum voluptatem. Qui reprehenderit beatae est maxime sit a modi. Suscipit veritatis nostrum voluptatibus dolor sed. Quibusdam ad molestiae non non.
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...