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

  • Thread starter Thread starter JustSomeGuy
  • Start date Start date
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?
 
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
 
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.
 
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.
 
Back
Top