Excel: Excel chart does not plot entire data series


I have a chart with two vertical axis that charts up to four data series. There is one horizontal axis, but the ranges of each data series may be longer or shorter than the others. Here is an example function for one of the series

=SERIES("GOOGL P/E ratio relative to an index (right axis)",'DATA-Index'!$A$154:$A$256,'DATA-Internet'!$BH$154:$BH$256,3)
Notice that this series is 256 - 154 + 1 = 103 data elements long for both the series itself and the points used for the horizontal axis (which happen to be dates). However, the chart that gets generated displays only 30 of the points. When I right-click on the series, and choose Select Data and click Edit for both the Series and the horizontal axis labels, all 103 points get highlighted. So what gives?


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of September 06, 2014.


For more resources for Microsoft Excel