Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    source for Excel graphs (2003)

    Is there a way I can use the source below for a bar graph. The asterisk next to the 22% doesn't get recognized and the bar is blank. thank you.

    Blue 14%
    Red 30%
    White 22%*

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

    Re: source for Excel graphs (2003)

    If 22%* is in one cell, the asterisk makes it into a text value. Text values aren't plotted. Either remove the asterisk entirely, or put it in the next cell to the right.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: source for Excel graphs (2003)

    I was able to chart your numbers by applying a custom format to the 22%. Not sure if it's what you're after but you can see it in action on the attached spreadsheet. HTH
    - Ricky

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: source for Excel graphs (2003)

    bravo!

Posting Permissions

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