Min and Max Value Changes
in [Charts]
|
From: Herbert Seidenberg on 16 Apr 2010 12:40 Excel 2007 Chart Dynamic min, max points. No extra cells used. http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_16_10.xlsx Pdf preview: http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf
From: "David Biddulph" groups [at] on 16 Apr 2010 13:37 It tells you how under Charting in Excel help. Copy the data from the data sheet, then when you click on the chart you'll find Paste Special under Paste in the Clipboard group on the Home tab. I'm still trying to find my own way around Excel 2007, & particularly the charting functions. -- David Biddulph "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message news:C22228D8-5FC2-474B-B499-3B5C9D8F5C0C(a)microsoft.com... > 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 >> >> >> >> >> >> . >> >> >> >> . >>
From: Dave B on 16 Apr 2010 15:45 Herbert, Still no go. I underrstand the process you have provided and it is an elegant approach. My problem seems to boil down to the "Edit Series" box from the "Select Data" window. In your example, your "Edit Series" box contains "Series Name", "Series X Value" and "Series Y Value". The box I bring up contains only " Series Name" and "Series Value". where am I going wrong? -- Dave B "Herbert Seidenberg" wrote: > Excel 2007 Chart > Dynamic min, max points. > No extra cells used. > http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_16_10.xlsx > Pdf preview: > http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf > > . >
From: Mike Middleton on 16 Apr 2010 19:33 Dave B - In Excel 2007, if you have an XY (Scatter) chart type, the Edit Series dialog box will contain "Series name", "Series X values" and "Series Y values". If you have some other chart type, e.g., a Line chart type, the Edit Series dialog box will contain "Series name" and "Series values." Your original post said you had an XY chart. Maybe you don't. - Mike http://www.MikeMiddleton.com "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message news:8BA0855F-F3B8-4066-85D8-7CD889AEB985(a)microsoft.com... > Herbert, > Still no go. > I underrstand the process you have provided and it is an elegant approach. > My problem seems to boil down to the "Edit Series" box from the "Select > Data" > window. In your example, your "Edit Series" box contains "Series Name", > "Series X Value" and "Series Y Value". The box I bring up contains only " > Series Name" and "Series Value". where am I going wrong? > -- > Dave B > > > "Herbert Seidenberg" wrote: > >> Excel 2007 Chart >> Dynamic min, max points. >> No extra cells used. >> http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_16_10.xlsx >> Pdf preview: >> http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf >> >> . >>
From: Dave B on 26 Apr 2010 11:16
Sorry for the late response. you were correct, I had been working with the wrong chart type. Thanks to all for your help. -- Dave B "Mike Middleton" wrote: > Dave B - > > In Excel 2007, if you have an XY (Scatter) chart type, the Edit Series > dialog box will contain "Series name", > "Series X values" and "Series Y values". > > If you have some other chart type, e.g., a Line chart type, the Edit Series > dialog box will contain "Series name" and "Series values." > > Your original post said you had an XY chart. Maybe you don't. > > - Mike > http://www.MikeMiddleton.com > > > > "Dave B" <DaveB(a)discussions.microsoft.com> wrote in message > news:8BA0855F-F3B8-4066-85D8-7CD889AEB985(a)microsoft.com... > > Herbert, > > Still no go. > > I underrstand the process you have provided and it is an elegant approach. > > My problem seems to boil down to the "Edit Series" box from the "Select > > Data" > > window. In your example, your "Edit Series" box contains "Series Name", > > "Series X Value" and "Series Y Value". The box I bring up contains only " > > Series Name" and "Series Value". where am I going wrong? > > -- > > Dave B > > > > > > "Herbert Seidenberg" wrote: > > > >> Excel 2007 Chart > >> Dynamic min, max points. > >> No extra cells used. > >> http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_16_10.xlsx > >> Pdf preview: > >> http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf > >> > >> . > >> > . > |