Chart Labels not refreshing

  • Thread starter Thread starter Chris Robinson
  • Start date Start date
C

Chris Robinson

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
 
Hi,

I've filled in the gaps below ;o)
-----Original Message-----
What did this person chart? In what kind of a chart?
Click to expand...

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>)?
Click to expand...

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?"
Click to expand...

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?
Click to expand...

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 :o)
 
Sounds like the Calculation Mode is set to Manual.

Pressing F9 and see if the chart and equation update.

Chris said:
Hi,

I've filled in the gaps below ;o)




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

When one clicks


bar contain?



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




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.



values? Or both


the "resulting



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 :o)
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
I tried that already - it's set to automatic and still
doesn't work :o( Thanks for the suggestion though.

Chris.
 
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
 
Back
Top