Dynamic Charting

You guys rock on this site!

That worked perfectly.

Does Excel allow for dynamic charting. What I mean by this is, Can I set up a graph ina worksheet and as my data changes, so does the outlook of my chart... for example, with the above lookup question data...lets say I wanted to set up a chart that allowed for a bar graph that showed monthly expenditure for gas...

Jan = $150.00
Feb = $124.00
Mar = $167.00
Apr = $179.00
May = $180.00
Jun = $46.00

As I continue to add to June's worksheet and the gas totals go up, can I display a graph that will continue to change as the amounts change...rather then going in and computing a graph each time I want to see my results graphically?

Thanks a bunch for the answer to my other question!!!!!!!!!

Thanks for the Info!