Re: update source & changes chart

From: Jon Peltier (jonNO_at_SPAMpeltiertech.com)
Date: 04/10/04 

Date: Fri, 09 Apr 2004 21:46:16 -0400

David -

1. I think the slider you refer to must be a symptom of the web
interface for the newsgroups. That panel is part of the web interface
experience, and as such, you're stuck with it. But you can use a
newsreader instead (Outlook Express or Netscape), and point it to
msnews.microsoft.com, and the interface is more satisfying.

2. Look at the dynamic examples and links on this page. You can set up
named ranges that adjust which data is visible in a chart.

   http://peltiertech.com/Excel/Charts/Dynamics.html

In addition, in Excel 2003, you can define your data range as a List,
and when the list is adjusted, if the chart is based on whole columns of
the list, it will reflect the new dimensions of the list. (I don't have
2003 installed, so I can't check this for sure. But a very highly placed
source at Microsoft described this to me.)

3. I'm not sure what you are describing. Are you changing just the Y
values, or also the X values? What data is used for the X values?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

David wrote:

> Hi, First, how do i get rid of the slider on the left in this group
> showing all of the group choices.
>
> Second, is there a way to automaticely update the source data. I am
> inserting a new line of data at the top of and existing data set and
> like adding data at the top of a formula, etc excel does not
> recognize the new data. Does not appear that charting includes the
> "titles", thus allowing to add the new data with auto update.
>
> Third, when I go in and manualy update the source, by changing the
> row number from 3 to 2, picking up the new row added, the chart
> changes. It is a time series chart, left to right, oldest to newest.
> It reverses the the time order, newest to oldest.
>
> I am using Microsoft Office Professional Edition 2003, running under
> XP Home Edition

Relevant Pages

  • Re: Office 2008 - Excellent
    ... I like the interface much better than Office 2004. ... Another really great thing is Microsoft did not incorporate the irritating activation requirements like it does on its Windows products. ... If you go to the microsoft.public.mac.office newsgroup, you will see a discussion where Excel appears to be missing the Data Analysis Toolpack Add in, as well as certain ways to add error bars to graphs. ...
    (comp.sys.mac.advocacy)
  • RE: Why so many "Service Temporarily Unavailable" errors here?
    ... i have contacted microsoft about this throught this site... ... but can't seem to fix their own web interface. ... rule out any local corporate firewall issues.) ...
    (microsoft.public.excel.programming)
  • Re: Office 2008 - Excellent
    ... work quite well with no obvious bugs found. ... I like the interface much ... with it even if it is from Microsoft. ... Apparently, there are other shortcomings in Excel, at least. ...
    (comp.sys.mac.advocacy)
  • Re: Office 2007 - Keep user interface alone
    ... For those who want the old unintuitive interface, you have an option - don't ... | a handle on finding popular commands. ... (2007 Microsoft Office system ... | Wondering where your favorite Excel 2003 commands are located in the ...
    (microsoft.public.officeupdate)
  • Word reparieren und komplett neu registrieren
    ... Wir haben eine App die Word fernsteuert. ... (Es sieht so aus, das Microsoft kein Überblick mehr hat, welche Interface da ... meist wenn man Excel aktualisiert, ...
    (microsoft.public.de.word)
Loading