Secondary Axis Data Series "Clumping"

[Mike]

I have a chart that has 3 data series. 2 are related to percentages and are
tied to the primary axis. The third series is a whole number, and tied to
the secondard axis. it has always displayed properly.

For some reason the data tied to the secondary axis is "clumping". That is,
all 17 data points are displaying before the second category tick. The
first 2 series' data is displaying just fine.

What have i done wrong?

 

[Jon Peltier]

What are the chart types of the three series?

- Jon

 

[Mike]

All three are line charts.

I noticed that although all three series referenced the same column of
dates, for the the third the dates looked "different" within the select data
dialog box. i tried making sure the dates were all formatted the same, no
affect. i finally changed the dates (just months and years) to text entries
(added a apotrophe) and the chart displays fine. My issue is with the dates
somehow. Again, this chart displayed fine last month. Thoughts?

Thanks for your help.

 

[Jon Peltier]

Make sure you are using exactly the same date range for all three series.

Make sure there is a secondary Y axis but not a secondary X axis.

- Jon