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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|