how do I create a chart that adds new data to it automatically?
I read something about using a "name" or "named range" to do this but I'm kinda over my head a bit.
The data is simple for now, just dates with revenue projections, so two columns, one for dates and one for simple dollar amounts.
if someone can help I would greatly appreciate it!