Wonky Area Graph Problem
 

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 he
http://ken.net/images/WonkyAreaGraph.jpg

Any help would be appreciated.

Wonky Area Graph Problem
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______



"Ken Snyder" wrote in message
...
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 he
http://ken.net/images/WonkyAreaGraph.jpg

Any help would be appreciated.

Wonky Area Graph Problem
 

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...

:o)

All the best,

John




"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______



"Ken Snyder" wrote in message
...
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 he
http://ken.net/images/WonkyAreaGraph.jpg

Any help would be appreciated.