A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Min and Max Value Changes



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2010, 09:14 PM posted to microsoft.public.excel.charting
Dave B
external usenet poster
 
Posts: 39
Default Min and Max Value Changes

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
  #2  
Old April 15th, 2010, 09:26 PM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Min and Max Value Changes

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" wrote in message
...
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



  #3  
Old April 15th, 2010, 11:31 PM posted to microsoft.public.excel.charting
Dave B
external usenet poster
 
Posts: 39
Default Min and Max Value Changes

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" wrote in message
...
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



.

  #4  
Old April 16th, 2010, 07:45 AM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Min and Max Value Changes

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/ex...491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/...leId=9028 218

If there is some specific stage, tell us which.
--
David Biddulph


"Dave B" wrote in message
...
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" wrote in message
...
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



.


  #5  
Old April 16th, 2010, 04:24 PM posted to microsoft.public.excel.charting
Dave B
external usenet poster
 
Posts: 39
Default Min and Max Value Changes

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/ex...491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/...leId=9028 218

If there is some specific stage, tell us which.
--
David Biddulph


"Dave B" wrote in message
...
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" wrote in message
...
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


.


.

  #6  
Old April 16th, 2010, 05:40 PM posted to microsoft.public.excel.charting
Herbert Seidenberg
external usenet poster
 
Posts: 1,113
Default Min and Max Value Changes

Excel 2007 Chart
Dynamic min, max points.
No extra cells used.
http://c0718892.cdn.cloudfiles.racks.../04_16_10.xlsx
Pdf preview:
http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf

  #7  
Old April 16th, 2010, 06:37 PM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Min and Max Value Changes

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" wrote in message
...
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/ex...491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/...leId=9028 218

If there is some specific stage, tell us which.
--
David Biddulph


"Dave B" wrote in message
...
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" wrote in message
...
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


.


.


  #8  
Old April 16th, 2010, 08:45 PM posted to microsoft.public.excel.charting
Dave B
external usenet poster
 
Posts: 39
Default Min and Max Value Changes

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.racks.../04_16_10.xlsx
Pdf preview:
http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf

.

  #9  
Old April 17th, 2010, 12:33 AM posted to microsoft.public.excel.charting
Mike Middleton[_2_]
external usenet poster
 
Posts: 90
Default Min and Max Value Changes

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" wrote in message
...
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.racks.../04_16_10.xlsx
Pdf preview:
http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf

.

  #10  
Old April 26th, 2010, 04:16 PM posted to microsoft.public.excel.charting
Dave B
external usenet poster
 
Posts: 39
Default Min and Max Value Changes

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" wrote in message
...
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.racks.../04_16_10.xlsx
Pdf preview:
http://www.mediafire.com/file/mr2gzzynhig/04_16_10.pdf

.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.