+ Reply to Thread
Results 1 to 7 of 7

Charting Problem, Colored Boxes (Picture Included)

  1. #1
    Registered User
    Join Date
    03-14-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2008
    Posts
    4

    Unhappy Charting Problem, Colored Boxes (Picture Included)

    Hello,

    First of all, I want to apologize in advance if this is in on the wrong board... I figured this was close enough?

    So, here's my problem... http://s5.tinypic.com/2wpmiph.jpg

    I'm trying to chart some data I have, but every time I go to chart it... something happens. I wish I knew more technical terms to explain this situation, but I don't. Hopefully that image above will be enough for you guys see my problem.

    Some other information... it will allow me to correctly plot from 15-Jan to 2-Feb, but after that, it causes the chart to come out weirdly.

    Also, the version of Excel I am using is 2008 (12.1.0) for the Mac.

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    03-14-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: Charting Problem, Colored Boxes (Picture Included)

    I am so sorry...

    I was wrong about the location of this post.

    I just now found the correct forum. Should I delete this post then repost it there?

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Charting Problem, Colored Boxes (Picture Included)

    Please post a workbook rather than a picture and explain what you mean by,
    "...come out weirdly...".
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    03-14-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: Charting Problem, Colored Boxes (Picture Included)

    Hopefully this helps!

    .xls file attached.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Charting Problem, Colored Boxes (Picture Included)

    Your value in B11 is wrong ( 106. 68)
    Type the value in manually and redraw the graph. It should be OK

  6. #6
    Registered User
    Join Date
    03-14-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: Charting Problem, Colored Boxes (Picture Included)

    Thank you!

    That fixed it! I knew there had to be some silly like that causing a problem. I don't know how I managed to miss that!

  7. #7
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Charting Problem, Colored Boxes (Picture Included)

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1