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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JustSomeGuy - 19 Jan 2008 22:13 GMT

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?

Reply to this Message

ShaneDevenshire - 21 Jan 2008 16:17 GMT

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

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

Reply to this Message

Bob W - 21 Jan 2008 16:36 GMT

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.

> Hi,
>
[quoted text clipped - 11 lines]
> > When I change data in the table, the bar chart never updates. I am
> > relatively new to Excel. What am I missing?

Reply to this Message

Bob W - 21 Jan 2008 16:38 GMT

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.

> Hi,
>
[quoted text clipped - 11 lines]
> > When I change data in the table, the bar chart never updates. I am
> > relatively new to Excel. What am I missing?

Reply to this Message