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  

maximun & minimum data labels



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2003, 10:27 AM
glen
external usenet poster
 
Posts: n/a
Default maximun & minimum data labels

when showing data labels within a chart i only want to
show a maxmium & a minimum not all the values \. can this
be done
thanks
  #2  
Old September 15th, 2003, 10:58 AM
Andy Pope
external usenet poster
 
Posts: n/a
Default maximun & minimum data labels

Hi Glen,

Here are two ways of do these.
If it is a once off task then you can select the individual data points
and apply data labels to just those points.
Select the data series and the click the Maximum data point.
Right click to format that specific point. Apply data labels.

To do it in a more dynamic way would require the use of some formulas.
The formula would display the value of only the min and max data.
The data labels could then be linked to the cells.

Asumming your data is in B2:B8 then enter a formula something like this
into C2:C8;
=IF(B2=MAX(B$2:B$8),"Max " & B2,IF(B2=MIN(B$2:B$8),"Min "& B2,""))

Using one of these two free addins will help with the linking.

Rob Bovey's XY Chart Labeler:
http://www.appspro.com/utilities/utilities.asp

JWalk Chart Tools:
http://j-walk.com/ss/excel/files/charttools.htm

glen wrote:
when showing data labels within a chart i only want to
show a maxmium & a minimum not all the values \. can this
be done
thanks


--

Cheers
Andy

http://www.andypope.info

  #3  
Old September 16th, 2003, 04:43 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default maximun & minimum data labels

Andy -

I find this is slightly better if I split the formula, using the max
formula in column C and the min formula in column D. Then I add both
columns as additional series. This way I can use a custom marker for
Max and for Min, and I can format the Max labels to appear above the
plotted points, and the Min labels below the points.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:
Hi Glen,

Here are two ways of do these.
If it is a once off task then you can select the individual data points
and apply data labels to just those points.
Select the data series and the click the Maximum data point.
Right click to format that specific point. Apply data labels.

To do it in a more dynamic way would require the use of some formulas.
The formula would display the value of only the min and max data.
The data labels could then be linked to the cells.

Asumming your data is in B2:B8 then enter a formula something like this
into C2:C8;
=IF(B2=MAX(B$2:B$8),"Max " & B2,IF(B2=MIN(B$2:B$8),"Min "& B2,""))

Using one of these two free addins will help with the linking.

Rob Bovey's XY Chart Labeler:
http://www.appspro.com/utilities/utilities.asp

JWalk Chart Tools:
http://j-walk.com/ss/excel/files/charttools.htm

glen wrote:

when showing data labels within a chart i only want to show a maxmium
& a minimum not all the values \. can this be done thanks




 




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 03:21 PM.


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