How to plot positive and negative values on both sides of the axis in Excel

Insert -> Scatter -> Scatter with Smooth Lines and Markers will give you that type of graph

This does require the data to be next to each other e.g.:

XYY
1 1 2
2 2 4
3 3 6
4 4 8

Where column 1 is x-value and columns 2-# are the y-values

You can do this in Excel!!! In fact, there are at least two ways to create a chart like this:

The first method is easiest, but requires a free add-in (that every Excel user probably should have anyway), Rob Bovey's XY Chart Labeler.

1. Set up your data (as described).
2. Add your data as a single Scatter (XY) data series.
3. Use XY Chart Labeler (its awesome) to Add Labels to your data series, using the Date data column (formatted to just days [dd] in this sample), located above your data point.
4. Format everything to your taste.

Otherwise, you can do it this way.

1. Set up your data (as described).
2. Add your data as one Scatter (XY) data series for every row in your data (one per day, in this sample). So, if you have 31 days, you'll have 31 series.
3. Add your data labels using the data points name, located above your data point.
4. Format everything to your taste (including all 31 data series and their labels).

I'd strongly recommend the first method, or using VBA to expedite the second.