Lost functionality in Excel 2007

  • Thread starter Thread starter mattabat
  • Start date Start date
M

mattabat

Hello,
I often make scatter charts within Excel and I like to add trendlines
to these charts, with the equations and associated R^2 values. With
previous versions of Excel I could increase the precision of the
equations using the "Increase Decimal" function in the toolbar. This
has handy when one didn't want to manually recalculate the trendline
to access reasonably precise values for the trendline.
I tried to do this with Excel '07 and it doesn't work.
I know this is a minor example, but has anyone run across any other
lost functionalities in Excel, or indeed anywhere in the Office suite?
 
Mattabat

There is a ton of 'disconnects' in the charting functionality as in this
release it became a 'shared' object across all Office apps. Expect things
like this, if MS see's it as frequently used to make a comeback in either a
SP (about 6-9months) or the next release (2009???)

It is frustrating when something you used a lot is not working, but in
general, to get a new release out they have to cut some things and 'try' to
make these less used features.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 
Nick Hodge said:
but in general, to get a new release out they have to cut some
things and 'try' to make these less used features.
Click to expand...
....

There's deliberately dropping features, and documenting the fact,
e.g., Lotus 123 file format support, and there's silently failing to
implement previous features, widely used or less used, and failing to
DOCUMENT that fact. It's the failure to document (not exactly
something new for MSFT) that leads one to suspect no one bothered to
put such dropped features on a To-Do list. IOW, a certain suspicion
that omission was due to negligence rather than intent seems fair.
 
Hello,
I often make scatter charts within Excel and I like to add trendlines
to these charts, with the equations and associated R^2 values. With
previous versions of Excel I could increase the precision of the
equations using the "Increase Decimal" function in the toolbar. This
has handy when one didn't want to manually recalculate the trendline
to access reasonably precise values for the trendline.
I tried to do this with Excel '07 and it doesn't work.
I know this is a minor example, but has anyone run across any other
lost functionalities in Excel, or indeed anywhere in the Office suite?
Click to expand...

Hi,

First point - although you can't change the decimal places for R-
square and the Equation using the increase and decrease toolbar
buttons, you can still accomplish achieve the same results by right
clicking and choosing Format Trendline Label.
Regarding the second question - other lost functionality. In a word
TNTC - too numerous to count!

Cheers,
Shane A. Devenshire
Microsoft Excel MVP
 
Back
Top