To make the area chart change vertically up or down at a single X value,
you need to use some kind of numerical values, not categories. Where you
want the vertical change, put a duplicate number for X, and put both
values for Y. This data for example, will produce an area chart that
ramps upward, and at X=4, it drops from 6 to 2:

Value
1 3
2 4
3 5
4 6
4 2
5 2

Plot the data, then using Chart Options from the Chart menu, click on
the Axes tab, and change to a time-scale category axis. This turns 1
through 5 to 1/1/1900 to 1/5/1900, so double click on the X axis, and
change the number format to something other than a date.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


jarvo wrote:
sorry about the late reply, been away and i forgot i posted this :D

basically i have an area graph, the "Won" part goes smoothly up then
smoothly down like a hill.
i want it to go smoothly up then straight down, like a cliff.

hard to explain with out pictures.

The attachemnts are fine, no virus or anything else.