Graph automatic update

[jrortiz2]

hi Guys,

I need to create an excel chart which will automatically update if i added new rows and data on my work sheet. Is there any possible way to do it?

Please see attachment for the graphs i made

Thanks

[Andy Pope]

If you convert your range to a table then the chart will automatically extend.

Your table can include a Total row, although it would not match the figures you currently have in your Grand Total row.

[jrortiz2]

Thanks for the Help Andy