how to make chart do not show zero values ms excel?

Here I will show you how to do it by an example:
1.Enter the following data into cells D1 to D5:
4,12,49,24,65.
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.
7.Click OK.
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.
 

Answered Nov, 16 2010

In the pivot table below, we want to hide the Order ID value that is blank.
look this:



In the pivot table below, we want to hide the Order ID value that is blank.



Now whenever the OrderID is blank, the data will be hidden in the pivot table.

Answered Jan, 23 2011

Now, calculate a trendline:

1. Click in the chart area to select the chart.The Chart menu appears when the chart is selected.
2. On the Chart menu, click Add Trendline.
3. In the Add Trendline dialog box, click the Type tab.
4. Under Trend/Regression type, click Linear(or logarithmic or moving average). This creates a straight trendline.
5. Click OK. Answered Nov, 29 2010