Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Marc
 
Posts: n/a
Default Why doesn't my chart update when underlying data changes?

when the source data of my chart changes, the chart does not update
accordingly. Is there a refresh button like in pivot tables that I can press
to update the chart?
  #2   Report Post  
Posted to microsoft.public.excel.charting
bernard liengme
 
Posts: n/a
Default Why doesn't my chart update when underlying data changes?

Do you mean:
a) when you add data to the worksheet, the new data is not displayed? If so
read www.stfx.ca/people/bliengme/ExcelTips to learn about dynamic chart; OR
if sing XL2003 make a 'list' and the chart will be dynamic,
or
b) if you change existing data, the chart is unchanged. When ou clcik on the
line in the chart, does Excel draw a box around the data in the cells?

come back for more

best wishes
Bernard

"Marc" wrote in message
...
when the source data of my chart changes, the chart does not update
accordingly. Is there a refresh button like in pivot tables that I can
press
to update the chart?



  #3   Report Post  
Posted to microsoft.public.excel.charting
Marc
 
Posts: n/a
Default Why doesn't my chart update when underlying data changes?

Hi Bernard,

It's not new data, it's existing data that I change and it does not get
reflected in the chart. When I click on the line, no line appears around the
source data cells

"bernard liengme" wrote:

Do you mean:
a) when you add data to the worksheet, the new data is not displayed? If so
read www.stfx.ca/people/bliengme/ExcelTips to learn about dynamic chart; OR
if sing XL2003 make a 'list' and the chart will be dynamic,
or
b) if you change existing data, the chart is unchanged. When ou clcik on the
line in the chart, does Excel draw a box around the data in the cells?

come back for more

best wishes
Bernard

"Marc" wrote in message
...
when the source data of my chart changes, the chart does not update
accordingly. Is there a refresh button like in pivot tables that I can
press
to update the chart?




  #4   Report Post  
Posted to microsoft.public.excel.charting
bernard liengme
 
Posts: n/a
Default Why doesn't my chart update when underlying data changes?

So somehow the data is not linked to the chart - this can happen if you
click on the chart, place the cursor in the Formual Bar and press F9. Right
clcik the chart and select Source Data and open the Series tab to see what
the chart is using for data. if you see somethinh like {1,2,3,} your chart
is disconected from its data.You may need to remake the chart.
Bernard



"Marc" wrote in message
...
Hi Bernard,

It's not new data, it's existing data that I change and it does not get
reflected in the chart. When I click on the line, no line appears around
the
source data cells

"bernard liengme" wrote:

Do you mean:
a) when you add data to the worksheet, the new data is not displayed? If
so
read www.stfx.ca/people/bliengme/ExcelTips to learn about dynamic chart;
OR
if sing XL2003 make a 'list' and the chart will be dynamic,
or
b) if you change existing data, the chart is unchanged. When ou clcik on
the
line in the chart, does Excel draw a box around the data in the cells?

come back for more

best wishes
Bernard

"Marc" wrote in message
...
when the source data of my chart changes, the chart does not update
accordingly. Is there a refresh button like in pivot tables that I can
press
to update the chart?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Range Mess Karen Charts and Charting in Excel 18 January 14th 06 03:34 PM
Update and add new row of data help? [email protected] Excel Worksheet Functions 1 July 28th 05 03:57 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"