Charting Problem, Colored Boxes (Picture Included)

**KPDUF** · 03-14-2009, 03:58 PM

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!

**KPDUF** · 03-14-2009, 04:20 PM

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?

**protonLeah** · 03-14-2009, 04:27 PM

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

**KPDUF** · 03-14-2009, 04:31 PM

Hopefully this helps!

.xls file attached.

**arthurbr** · 03-14-2009, 04:48 PM

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

**KPDUF** · 03-14-2009, 04:55 PM

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!

**arthurbr** · 03-14-2009, 05:03 PM

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