Excel – How to create a graph with two Y axis with different values in Excel

Make sure you have a scatter chart in Excel

Here is the difference:

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.