Wonky Area Graph Problem

[Ken Snyder]

For a project I'm working on I have an area graph that has two series (actual
data and projected data). As the x-axis has weekly data i'd like the point of
the "actual data" to flow right into the "forecasted data". This works but
for some bizarre reason the vertical line that separates these two areas is
not purely vertical but slants backward to the left.

Probably best to show a picture of this. I've posted it here:
http://ken.net/images/WonkyAreaGraph.jpg

Any help would be appreciated.

 

[Jon Peltier]

Your data is like

actual projected
1-jan-07 100 0
2-jan-07 110 0
3-jan-07 0 120
4-jan-07 0 130

so you have a line in the actual series from {2-jan-07, 110} to {3-jan-07,
0}, which slopes downward, and another in the projected series from
{2-jan-07, 0} to {3-jan-07, 120}, which would slope upwards, except it
nicely fills in next to the downward sloping line.

Keeping a time-scale axis, change your data like this, so you have two
points for each series on the date where the vertical transition belongs:

actual projected
1-jan-07 100 0
2-jan-07 110 0
2-jan-07 0 110
3-jan-07 0 120
4-jan-07 0 130

The lines are now defined at {2-jan-07, 110} to {2-jan-07, 0} and {2-jan-07,
0} to {2-jan-07, 110}, with both endpoints on the same date, thus they are
vertical.

- Jon

 

[John_K]

Another way to do this is the following...

This is a 'feature' of excel i think...

Right click your graph and turn it into a line graph
You soft stop data SHOULD stop in mid air now
Click on the data line that you want to turn into a area graph
Right click on the line and then select Chart Type
Change the chart type to Area Fill graph...

Do for all the data lines on the graph you want to

Roberts your Dads brother...

)

All the best,

John