bar charts don't udate when data is changed-why?

J

JustSomeGuy

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?
 
S

ShaneDevenshire

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
 
B

Bob W

it says the chart data range is too complex to be displayed...but it's just a
simple stacked bar chart with 4 values in it.
 
B

Bob W

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.
 
Top