also I should say I did try changing one of the numbers in the stacked bar,
but as described earlier, it makes no change in the bar chart.

"ShaneDevenshire" wrote:

Hi,

The updated data is probably outside the old data range. You can check that
by temporarily replacing one of the entries that is being plotted correctly.
If that's the problem you need to extend the plot ranges. There are other
possibilities.

cheers,
Shane


"JustSomeGuy" wrote:

I inherited a spreadsheet with data on sheet 1 and an Excel-generated bar
chart on sheet 2. The table is NOT a pivot table.

When I change data in the table, the bar chart never updates. I am
relatively new to Excel. What am I missing?