Why Color Flled Data Series on Line Chart Slants

[Guest]

I have a modified line chart showing cumulative product cost over a twelve
month period. The x-axis shows each month, and the data line moves right and
up increasing with the cumulative total for the months. Right now, the first
six months are actual and second six months are projected. Each side is
color filled (using Format Data Series Fill Effects) and there is a vertical
line showing the separation. For some reason the color fill and vertical
line are slanting, indicating different month points between the data line
and the x axis. Any idea what might be causing this and/or how to fit it?

 

[Jon Peltier]

I can't read your writing. Do you mean there's an alternating slanted fill
pattern?

- Jon

 

[Guest]

No, both the line and color slant together. The problem is that I do not
want the slant. I want the line and color to be straight up and down from
the point on the line to the point on the x-axis. However, the point of a
given month (say March) on the line is not matching up with that same
point/month of the x-axis. Unfortunately, I cannot post a visual to make it
easierto see what I am talking about.

 

[Jon Peltier]

"alternating slanted fill pattern" was my best guess, but that was wrong.
Now I have no idea what you are describing.

- Jon

 

[Andy Pope]

Hi,

Are you using a couple of data series as areas to provide the shading?
If so you probably have a slanted line at the separation point as one
series drops to zero and the other starts from zero.
To get around this you need to plot the area series on a date based axis.

If not then I'm as lost as Jon to your actual problem.

Cheers
Andy

 

[Jon Peltier]

Hmmm, do you want this:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

If the site is down, it's because their web server went belly up. They're in
the process of setting up a nice new shiny box, and it should be available
in a couple days.

- Jon