Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2005
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphs with labels (2003)

    Have this workbook with the results of a survey. I have used 3D graphs to show the results. Because of the number of responses I show the labels in the graphs. So people having a look at the results, can see the results instantly.
    The problem is the Zeros. Is there any way I can have the labels in the graphs, but only show the actual amounts and no zeros.
    I have attached a pdf of a graph for clarity.
    There are about 30 graphs in total.
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graphs with labels (2003)

    You can set the number format for the source data to <code>0;0;;</code>. The last semicolon suppresses the display of zeros.
    You can also do this for the data labels themselves, but you'd have to do it for each series separately.

  3. #3
    Lounger
    Join Date
    May 2005
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphs with labels (2003)

    That worked. Thanks so much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •