You could use a Custom number format to hide the 200:
Double-click on the X axis, to open the Format Axis dialog box
On the Number tab, click on the Custom Category
In the Type box, enter: [=200]"";General
Click OK
alanas wrote:
Thank you a lot. Now it works.
I have one more question about charting:
I'm using XY diagram. And X line is growing from 0 to 500 by step 100, e.g.
0 100 200 300 400 500. But on diagram I will never have a point for 200. So
is it possible to skip the number 200? Of course the distance between 100 and
300 hundred must be 200, only without the number "200".
"Debra Dalgleish" wrote:
In the pivot table, double-click on the Type button in the row area.
Add a check mark to 'Show items with no data', then click OK
Then all the types should show, even if they have no data for the
selected city.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html