a common problem with Excel charts is
that sometimes people add more data to
the spreadsheet and forget to include
the new data in the chart and that's
exactly what's happened here our last
few rows are missing from the chart the
worst part is you may not even realize
that your chart is using incomplete or
out-of-date and data but I'm going to
show you an easy way to make sure your
chart always stays up to date first I'll
delete the old chart now the trick is to
format your source data as a table to do
this just make sure one of the cells in
your data is selected then on the Home
tab go to format as table and you can
click whichever format you prefer it
really doesn't matter which one since
our data has a header row we'll leave
this checked and click OK
with the table still selected we'll go
to the insert tab and choose a chart
type and I'm going to go with a column
chart now if we add more data just below
the table it gets automatically looped
into the table and we know that it's
part of the table because as adding the
table formatting to each new row best of
all since our chart is connected to this
table the new rows are added to the
chart as well so this chart will always
stay up to date no matter how much data
we add
Goodwill Community Foundation creating
opportunities for a better life