Chart Labels not refreshing

Excel 2000, SP3.

I have a problem with a chart in excel. A user has created
a standard line chart from a table in Excel and has
selected to show the formula of the resulting line (y=mx+c)
on the chart. This works fine, but when the data i the
table is updated, the formula displayed for the line doesn;
t change. if you delete it and re-add it, it works fine.
The spreadsheet has no problems updating automatically on
other installation of Office 2000 on other PC's.

Any help would be greatly appreciated.

Thanks,
Chris.

What did this person chart? In what kind of a chart? When one clicks
on the plotted series on the chart, what does the formula bar contain?
=SERIES(<what's here>)?

How did s/he show the "formula of the resulting line?"

When the data change... what data change? Only the x values? Or both
the x and y values? Also, when the data change, does the "resulting
line" adjust itself? Or do both the line and the formula remain
unchanged?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <60b401c3b352$0509e2d0$a601280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> Excel 2000, SP3.
>
> I have a problem with a chart in excel. A user has created
> a standard line chart from a table in Excel and has
> selected to show the formula of the resulting line (y=mx+c)
> on the chart. This works fine, but when the data i the
> table is updated, the formula displayed for the line doesn;
> t change. if you delete it and re-add it, it works fine.
> The spreadsheet has no problems updating automatically on
> other installation of Office 2000 on other PC's.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Chris.
>

Hi,

I've filled in the gaps below ;o)

>-----Original Message-----
>What did this person chart? In what kind of a chart?

The person did a line chart from a standard 2-column table
containing numerical data.

When one clicks
>on the plotted series on the chart, what does the formula
bar contain?
>=SERIES(<what's here>)?

It contains the range of cells used in the chart and
highlights them e.g.
"=SERIES(,,Sheet1!$A$1:$A$8,1)" for column A
AND
"=SERIES(,,Sheet1!$B$1:$B$8,2)" for column B

>
>How did s/he show the "formula of the resulting line?"

If you add a tendline to the chart (right-click on one of
the lines> add trendline), you can go onto the "Options"
tab (for the trendline's properties) and check the box
that says "show equation on chart". This is the formula
he's looking at.

>
>When the data change... what data change? Only the x
values? Or both
>the x and y values? Also, when the data change, does
the "resulting
>line" adjust itself? Or do both the line and the formula
remain
>unchanged?

We've tried changing both X and Y values - it makes no
difference. The line doesn't adjust either. However,
deleting the formula and adding it again seems
to "refresh" the chart in some way.

Like I said, the spreadsheet works fine on other people's
PC's. It's an odd one?

Thanks in advance,
Chris )

>
>--
>Regards,
>
>Tushar Mehta, MS MVP -- Excel
>www.tushar-mehta.com
>Excel, PowerPoint, and VBA add-ins, tutorials
>Custom MS Office productivity solutions
>
>In article <60b401c3b352$0509e2d0$a601280a@phx.gbl>,
>anonymous@discussions.microsoft.com says...
>> Excel 2000, SP3.
>>
>> I have a problem with a chart in excel. A user has
created
>> a standard line chart from a table in Excel and has
>> selected to show the formula of the resulting line
(y=mx+c)
>> on the chart. This works fine, but when the data i the
>> table is updated, the formula displayed for the line
doesn;
>> t change. if you delete it and re-add it, it works
fine.
>> The spreadsheet has no problems updating automatically
on
>> other installation of Office 2000 on other PC's.
>>
>> Any help would be greatly appreciated.
>>
>> Thanks,
>> Chris.
>>
>.
>

Sounds like the Calculation Mode is set to Manual.

Pressing F9 and see if the chart and equation update.

Chris Robinson wrote:

> Hi,
>
> I've filled in the gaps below ;o)
>
>
>>-----Original Message-----
>>What did this person chart? In what kind of a chart?
>
>
> The person did a line chart from a standard 2-column table
> containing numerical data.
>
> When one clicks
>
>>on the plotted series on the chart, what does the formula
>
> bar contain?
>
>>=SERIES(<what's here>)?
>
>
> It contains the range of cells used in the chart and
> highlights them e.g.
> "=SERIES(,,Sheet1!$A$1:$A$8,1)" for column A
> AND
> "=SERIES(,,Sheet1!$B$1:$B$8,2)" for column B
>
>
>>How did s/he show the "formula of the resulting line?"
>
>
> If you add a tendline to the chart (right-click on one of
> the lines> add trendline), you can go onto the "Options"
> tab (for the trendline's properties) and check the box
> that says "show equation on chart". This is the formula
> he's looking at.
>
>
>>When the data change... what data change? Only the x
>
> values? Or both
>
>>the x and y values? Also, when the data change, does
>
> the "resulting
>
>>line" adjust itself? Or do both the line and the formula
>
> remain
>
>>unchanged?
>
>
> We've tried changing both X and Y values - it makes no
> difference. The line doesn't adjust either. However,
> deleting the formula and adding it again seems
> to "refresh" the chart in some way.
>
> Like I said, the spreadsheet works fine on other people's
> PC's. It's an odd one?
>
> Thanks in advance,
> Chris )
>
>
>>--
>>Regards,
>>
>>Tushar Mehta, MS MVP -- Excel
>>www.tushar-mehta.com
>>Excel, PowerPoint, and VBA add-ins, tutorials
>>Custom MS Office productivity solutions
>>
>>In article <60b401c3b352$0509e2d0$a601280a@phx.gbl>,
>>anonymous@discussions.microsoft.com says...
>>
>>>Excel 2000, SP3.
>>>
>>>I have a problem with a chart in excel. A user has
>
> created
>
>>>a standard line chart from a table in Excel and has
>>>selected to show the formula of the resulting line
>
> (y=mx+c)
>
>>>on the chart. This works fine, but when the data i the
>>>table is updated, the formula displayed for the line
>
> doesn;
>
>>>t change. if you delete it and re-add it, it works
>
> fine.
>
>>>The spreadsheet has no problems updating automatically
>
> on
>
>>>other installation of Office 2000 on other PC's.
>>>
>>>Any help would be greatly appreciated.
>>>
>>>Thanks,
>>>Chris.
>>>
>>
>>.
>>

--

Cheers
Andy

http://www.andypope.info

I tried that already - it's set to automatic and still
doesn't work ( Thanks for the suggestion though.

Chris.

>-----Original Message-----
>Sounds like the Calculation Mode is set to Manual.
>
>Pressing F9 and see if the chart and equation update.
>
>Chris Robinson wrote:
>
>> Hi,
>>
>> I've filled in the gaps below ;o)
>>
>>
>>>-----Original Message-----
>>>What did this person chart? In what kind of a chart?
>>
>>
>> The person did a line chart from a standard 2-column
table
>> containing numerical data.
>>
>> When one clicks
>>
>>>on the plotted series on the chart, what does the
formula
>>
>> bar contain?
>>
>>>=SERIES(<what's here>)?
>>
>>
>> It contains the range of cells used in the chart and
>> highlights them e.g.
>> "=SERIES(,,Sheet1!$A$1:$A$8,1)" for column A
>> AND
>> "=SERIES(,,Sheet1!$B$1:$B$8,2)" for column B
>>
>>
>>>How did s/he show the "formula of the resulting line?"
>>
>>
>> If you add a tendline to the chart (right-click on one
of
>> the lines> add trendline), you can go onto
the "Options"
>> tab (for the trendline's properties) and check the box
>> that says "show equation on chart". This is the
formula
>> he's looking at.
>>
>>
>>>When the data change... what data change? Only the x
>>
>> values? Or both
>>
>>>the x and y values? Also, when the data change, does
>>
>> the "resulting
>>
>>>line" adjust itself? Or do both the line and the
formula
>>
>> remain
>>
>>>unchanged?
>>
>>
>> We've tried changing both X and Y values - it makes no
>> difference. The line doesn't adjust either. However,
>> deleting the formula and adding it again seems
>> to "refresh" the chart in some way.
>>
>> Like I said, the spreadsheet works fine on other
people's
>> PC's. It's an odd one?
>>
>> Thanks in advance,
>> Chris )
>>
>>
>>>--
>>>Regards,
>>>
>>>Tushar Mehta, MS MVP -- Excel
>>>www.tushar-mehta.com
>>>Excel, PowerPoint, and VBA add-ins, tutorials
>>>Custom MS Office productivity solutions
>>>
>>>In article <60b401c3b352$0509e2d0$a601280a@phx.gbl>,
>>>anonymous@discussions.microsoft.com says...
>>>
>>>>Excel 2000, SP3.
>>>>
>>>>I have a problem with a chart in excel. A user has
>>
>> created
>>
>>>>a standard line chart from a table in Excel and has
>>>>selected to show the formula of the resulting line
>>
>> (y=mx+c)
>>
>>>>on the chart. This works fine, but when the data i
the
>>>>table is updated, the formula displayed for the line
>>
>> doesn;
>>
>>>>t change. if you delete it and re-add it, it works
>>
>> fine.
>>
>>>>The spreadsheet has no problems updating automatically
>>
>> on
>>
>>>>other installation of Office 2000 on other PC's.
>>>>
>>>>Any help would be greatly appreciated.
>>>>
>>>>Thanks,
>>>>Chris.
>>>>
>>>
>>>.
>>>
>
>--
>
>Cheers
>Andy
>
>http://www.andypope.info
>
>.
>

Tushar Mehta reminded us of this link a few days ago:

XL2002: Charts Do Not Update When Source Cells Are Updated
http://support.microsoft.com/defaul...kb;en-us;821644

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Chris Robinson wrote:
> I tried that already - it's set to automatic and still
> doesn't work ( Thanks for the suggestion though.
>
> Chris.
>
>
>>-----Original Message-----
>>Sounds like the Calculation Mode is set to Manual.
>>
>>Pressing F9 and see if the chart and equation update.
>>
>>Chris Robinson wrote:
>>
>>
>>>Hi,
>>>
>>>I've filled in the gaps below ;o)
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>What did this person chart? In what kind of a chart?
>>>
>>>
>>>The person did a line chart from a standard 2-column
>>
> table
>
>>>containing numerical data.
>>>
>>>When one clicks
>>>
>>>
>>>>on the plotted series on the chart, what does the
>>>
> formula
>
>>>bar contain?
>>>
>>>
>>>>=SERIES(<what's here>)?
>>>
>>>
>>>It contains the range of cells used in the chart and
>>>highlights them e.g.
>>>"=SERIES(,,Sheet1!$A$1:$A$8,1)" for column A
>>>AND
>>>"=SERIES(,,Sheet1!$B$1:$B$8,2)" for column B
>>>
>>>
>>>
>>>>How did s/he show the "formula of the resulting line?"
>>>
>>>
>>>If you add a tendline to the chart (right-click on one
>>
> of
>
>>>the lines> add trendline), you can go onto
>>
> the "Options"
>
>>>tab (for the trendline's properties) and check the box
>>>that says "show equation on chart". This is the
>>
> formula
>
>>>he's looking at.
>>>
>>>
>>>
>>>>When the data change... what data change? Only the x
>>>
>>>values? Or both
>>>
>>>
>>>>the x and y values? Also, when the data change, does
>>>
>>>the "resulting
>>>
>>>
>>>>line" adjust itself? Or do both the line and the
>>>
> formula
>
>>>remain
>>>
>>>
>>>>unchanged?
>>>
>>>
>>>We've tried changing both X and Y values - it makes no
>>>difference. The line doesn't adjust either. However,
>>>deleting the formula and adding it again seems
>>>to "refresh" the chart in some way.
>>>
>>>Like I said, the spreadsheet works fine on other
>>
> people's
>
>>>PC's. It's an odd one?
>>>
>>>Thanks in advance,
>>>Chris )
>>>
>>>
>>>
>>>>--
>>>>Regards,
>>>>
>>>>Tushar Mehta, MS MVP -- Excel
>>>>www.tushar-mehta.com
>>>>Excel, PowerPoint, and VBA add-ins, tutorials
>>>>Custom MS Office productivity solutions
>>>>
>>>>In article <60b401c3b352$0509e2d0$a601280a@phx.gbl>,
>>>>anonymous@discussions.microsoft.com says...
>>>>
>>>>
>>>>>Excel 2000, SP3.
>>>>>
>>>>>I have a problem with a chart in excel. A user has
>>>>
>>>created
>>>
>>>
>>>>>a standard line chart from a table in Excel and has
>>>>>selected to show the formula of the resulting line
>>>>
>>>(y=mx+c)
>>>
>>>
>>>>>on the chart. This works fine, but when the data i
>>>>
> the
>
>>>>>table is updated, the formula displayed for the line
>>>>
>>>doesn;
>>>
>>>
>>>>>t change. if you delete it and re-add it, it works
>>>>
>>>fine.
>>>
>>>
>>>>>The spreadsheet has no problems updating automatically
>>>>
>>>on
>>>
>>>
>>>>>other installation of Office 2000 on other PC's.
>>>>>
>>>>>Any help would be greatly appreciated.
>>>>>
>>>>>Thanks,
>>>>>Chris.
>>>>>
>>>>
>>>>.
>>>>
>>>
>>--
>>
>>Cheers
>>Andy
>>
>>http://www.andypope.info
>>
>>.
>>
>

Hi Jon,

Thanks for the info but this isn't a user-defined
function. It's just a standard chart created from a cell
range.

Rgds,
Chris

>-----Original Message-----
>Tushar Mehta reminded us of this link a few days ago:
>
>XL2002: Charts Do Not Update When Source Cells Are Updated
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;821644
>
>- Jon
>-------
>Jon Peltier, Microsoft Excel MVP
>http://www.geocities.com/jonpeltier/Excel/index.html
>_______
>
>Chris Robinson wrote:
>> I tried that already - it's set to automatic and still
>> doesn't work ( Thanks for the suggestion though.
>>
>> Chris.
>>
>>
>>>-----Original Message-----
>>>Sounds like the Calculation Mode is set to Manual.
>>>
>>>Pressing F9 and see if the chart and equation update.
>>>
>>>Chris Robinson wrote:
>>>
>>>
>>>>Hi,
>>>>
>>>>I've filled in the gaps below ;o)
>>>>
>>>>
>>>>
>>>>>-----Original Message-----
>>>>>What did this person chart? In what kind of a
chart?
>>>>
>>>>
>>>>The person did a line chart from a standard 2-column
>>>
>> table
>>
>>>>containing numerical data.
>>>>
>>>>When one clicks
>>>>
>>>>
>>>>>on the plotted series on the chart, what does the
>>>>
>> formula
>>
>>>>bar contain?
>>>>
>>>>
>>>>>=SERIES(<what's here>)?
>>>>
>>>>
>>>>It contains the range of cells used in the chart and
>>>>highlights them e.g.
>>>>"=SERIES(,,Sheet1!$A$1:$A$8,1)" for column A
>>>>AND
>>>>"=SERIES(,,Sheet1!$B$1:$B$8,2)" for column B
>>>>
>>>>
>>>>
>>>>>How did s/he show the "formula of the resulting line?"
>>>>
>>>>
>>>>If you add a tendline to the chart (right-click on one
>>>
>> of
>>
>>>>the lines> add trendline), you can go onto
>>>
>> the "Options"
>>
>>>>tab (for the trendline's properties) and check the box
>>>>that says "show equation on chart". This is the
>>>
>> formula
>>
>>>>he's looking at.
>>>>
>>>>
>>>>
>>>>>When the data change... what data change? Only the x
>>>>
>>>>values? Or both
>>>>
>>>>
>>>>>the x and y values? Also, when the data change, does
>>>>
>>>>the "resulting
>>>>
>>>>
>>>>>line" adjust itself? Or do both the line and the
>>>>
>> formula
>>
>>>>remain
>>>>
>>>>
>>>>>unchanged?
>>>>
>>>>
>>>>We've tried changing both X and Y values - it makes no
>>>>difference. The line doesn't adjust either. However,
>>>>deleting the formula and adding it again seems
>>>>to "refresh" the chart in some way.
>>>>
>>>>Like I said, the spreadsheet works fine on other
>>>
>> people's
>>
>>>>PC's. It's an odd one?
>>>>
>>>>Thanks in advance,
>>>>Chris )
>>>>
>>>>
>>>>
>>>>>--
>>>>>Regards,
>>>>>
>>>>>Tushar Mehta, MS MVP -- Excel
>>>>>www.tushar-mehta.com
>>>>>Excel, PowerPoint, and VBA add-ins, tutorials
>>>>>Custom MS Office productivity solutions
>>>>>
>>>>>In article <60b401c3b352$0509e2d0$a601280a@phx.gbl>,
>>>>>anonymous@discussions.microsoft.com says...
>>>>>
>>>>>
>>>>>>Excel 2000, SP3.
>>>>>>
>>>>>>I have a problem with a chart in excel. A user has
>>>>>
>>>>created
>>>>
>>>>
>>>>>>a standard line chart from a table in Excel and has
>>>>>>selected to show the formula of the resulting line
>>>>>
>>>>(y=mx+c)
>>>>
>>>>
>>>>>>on the chart. This works fine, but when the data i
>>>>>
>> the
>>
>>>>>>table is updated, the formula displayed for the line
>>>>>
>>>>doesn;
>>>>
>>>>
>>>>>>t change. if you delete it and re-add it, it works
>>>>>
>>>>fine.
>>>>
>>>>
>>>>>>The spreadsheet has no problems updating
automatically
>>>>>
>>>>on
>>>>
>>>>
>>>>>>other installation of Office 2000 on other PC's.
>>>>>>
>>>>>>Any help would be greatly appreciated.
>>>>>>
>>>>>>Thanks,
>>>>>>Chris.
>>>>>>
>>>>>
>>>>>.
>>>>>
>>>>
>>>--
>>>
>>>Cheers
>>>Andy
>>>
>>>http://www.andypope.info
>>>
>>>.
>>>
>>
>
>.
>