Percentage line chart
 

I need to create a percentage line chart based on the following an Arrival
and a Departure spreadsheet. The x axis is the dates and the y axis would
need to be the number of employees with 0 being in the middle of the graph,
not the bottom. After the line for the arrivals and the line for the
departures is on the graph, I then need to have a line showing the percentage
between the other two lines.
I have tried various ways of doing this, but with no success. Can anyone
help?

Percentage line chart
 

Zero in the middle is achieved by scaling the axis min and max
appropriately, then entering zero for Category Axis Crosses At.

For the third line, do you mean percentage difference between the first two
lines? Calculate the appropriate values in the worksheet, and use this range
of calculations as your source data for the added series.

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


"Jeannie" wrote in message
...
I need to create a percentage line chart based on the following an Arrival
and a Departure spreadsheet. The x axis is the dates and the y axis would
need to be the number of employees with 0 being in the middle of the
graph,
not the bottom. After the line for the arrivals and the line for the
departures is on the graph, I then need to have a line showing the
percentage
between the other two lines.
I have tried various ways of doing this, but with no success. Can anyone
help?