View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default bar charts don't udate when data is changed-why?

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?