who can tell me how to make chart do not show zero values ms excel? plz give me some guides. thanksAsked Jul, 19 2010
Here I will show you how to do it by an example:
1.Enter the following data into cells D1 to D5:
2.Click on cell f1 - where the results will be shown.
3.Click on the Formulas tab.
4.Choose More Functions > Statistical .
5.Click on MEDIAN
6.Drag select cells D1 to D5 in the spreadsheet to enter the range into the dialog box.
8.The answer 24 should appear in cell f1 since there are two numbers larger and two numbers smaller than it in the list.
9.The complete function = MEDIAN (D1 : D5) appears in the formula bar above the worksheet when you click on cell F1.
Search for Related Topics
ms excel raindrop charts ms excel bucket charts prepare chart ms excel graphical chart ms excel label parts ms excel chart notepad++ show distinct values ms excel box chart minimum median maximum ms excel simple marksheet chart show zeros excel starter excel columns hide show depending values ireport excel making charts coming values database c# show developer di ms excel 2003
Related Unresolved Questions