Why Color Flled Data Series on Line Chart Slants

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I can't read your writing. Do you mean there's an alternating slanted fill
pattern?

- Jon
 
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.
 
"alternating slanted fill pattern" was my best guess, but that was wrong.
Now I have no idea what you are describing.

- Jon
 
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
 
Back
Top