Min and Max Value Changes
in [Charts]
|
From: Dave B on 15 Apr 2010 16:14 I want to just label and highlight the min and max values in an XY chart and have them move appropriately if the data change. i saw a tutorial on line about doing so in 2003 but I can't get it to work in 2007. -- Dave B
From: "David Biddulph" groups [at] on 15 Apr 2010 16:26 Tell us how you did it in 2003, the hopefully we'll be able to tell you how to do it in 2007. I would have expected that on your data sheet you would have formulae to give the min and max, and then you'd use those as new series to add to your chart. -- David Biddulph "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message news:8F50F008-BCEA-4A62-B81D-255ADCA02A2F(a)microsoft.com... > I want to just label and highlight the min and max values in an XY chart > and > have them move appropriately if the data change. i saw a tutorial on line > about doing so in 2003 but I can't get it to work in 2007. > -- > Dave B
From: Dave B on 15 Apr 2010 18:31 See "http://processtrends.com/pg_charts_min_max.htm" -- Dave B "David Biddulph" wrote: > Tell us how you did it in 2003, the hopefully we'll be able to tell you how > to do it in 2007. > I would have expected that on your data sheet you would have formulae to > give the min and max, and then you'd use those as new series to add to your > chart. > -- > David Biddulph > > > "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message > news:8F50F008-BCEA-4A62-B81D-255ADCA02A2F(a)microsoft.com... > > I want to just label and highlight the min and max values in an XY chart > > and > > have them move appropriately if the data change. i saw a tutorial on line > > about doing so in 2003 but I can't get it to work in 2007. > > -- > > Dave B > > > . >
From: "David Biddulph" groups [at] on 16 Apr 2010 02:45 Yes, in general that looks like the way I would expect it to be done. Which part are you struggling with in 2007? If it is the general problem of translating 2003 menu instructions to corresponding 2007 commands, try: Some hints on 2003 to 2007 command mapping: http://office.microsoft.com/en-us/excel/HA101491511033.aspx http://www.rondebruin.nl/0307commands.htm http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218 If there is some specific stage, tell us which. -- David Biddulph "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message news:58ECF967-9F87-47D9-B845-7D63C8F22960(a)microsoft.com... > See "http://processtrends.com/pg_charts_min_max.htm" > > -- > Dave B > > > "David Biddulph" wrote: > >> Tell us how you did it in 2003, the hopefully we'll be able to tell you >> how >> to do it in 2007. >> I would have expected that on your data sheet you would have formulae to >> give the min and max, and then you'd use those as new series to add to >> your >> chart. >> -- >> David Biddulph >> >> >> "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message >> news:8F50F008-BCEA-4A62-B81D-255ADCA02A2F(a)microsoft.com... >> > I want to just label and highlight the min and max values in an XY >> > chart >> > and >> > have them move appropriately if the data change. i saw a tutorial on >> > line >> > about doing so in 2003 but I can't get it to work in 2007. >> > -- >> > Dave B >> >> >> . >>
From: Dave B on 16 Apr 2010 11:24
The formulas work, but the cut and paste doesn't. (from the earlier link, starting in step 4.) There is no "paste special" process and just cutting and pasting does not link the min and max data to the main data set. -- Dave B "David Biddulph" wrote: > Yes, in general that looks like the way I would expect it to be done. Which > part are you struggling with in 2007? If it is the general problem of > translating 2003 menu instructions to corresponding 2007 commands, try: > > Some hints on 2003 to 2007 command mapping: > http://office.microsoft.com/en-us/excel/HA101491511033.aspx > http://www.rondebruin.nl/0307commands.htm > http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218 > > If there is some specific stage, tell us which. > -- > David Biddulph > > > "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message > news:58ECF967-9F87-47D9-B845-7D63C8F22960(a)microsoft.com... > > See "http://processtrends.com/pg_charts_min_max.htm" > > > > -- > > Dave B > > > > > > "David Biddulph" wrote: > > > >> Tell us how you did it in 2003, the hopefully we'll be able to tell you > >> how > >> to do it in 2007. > >> I would have expected that on your data sheet you would have formulae to > >> give the min and max, and then you'd use those as new series to add to > >> your > >> chart. > >> -- > >> David Biddulph > >> > >> > >> "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message > >> news:8F50F008-BCEA-4A62-B81D-255ADCA02A2F(a)microsoft.com... > >> > I want to just label and highlight the min and max values in an XY > >> > chart > >> > and > >> > have them move appropriately if the data change. i saw a tutorial on > >> > line > >> > about doing so in 2003 but I can't get it to work in 2007. > >> > -- > >> > Dave B > >> > >> > >> . > >> > > . > |