How Can I Make a Graph in Excel Update it's Data Selection When I Add Rows?
Posted on 2013-06-13
I have a spreadsheet that is updated monthly with a new row for that month.
I have formulas that calculate various percentages etc..., so there are always a hundred rows or so of data (but not months), however, unless there is a month, and consequently data for the month, the formulas either give zeroes, or Div/Zero Errors
I have a set of graphs based on selected ranges of the formulas.
I would like the range to be a formula that detects the new row (month) and expands its graphic range to accomodate the new row.
Can somebody show me how to do that please? Thank you.