Percentage line chart

J

Jeannie

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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Labeling on independently stacked line chart 0
Graphs: 2 Lines on secondary Y-axis? 1
simple chart 0
Combining a 2-D column graph and a 2-D line graph on the same char 3
Odd chart type needed 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
X Axis to Scale 2
Make Y-axis values correspond to x- axis value 1

Top