# Excel chart does not plot entire data series

#### Hoozits

##### Active Member
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

Code:
``=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?

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Andrew Poulsom

##### MrExcel MVP
What's the formula for the other Series?

#### Hoozits

##### Active Member
There are actually 3 series, but here is another one

Code:
``=SERIES("FB P/E ratio relative to an index (right axis)",'DATA-Index'!\$A\$154:\$A\$256,'DATA-Internet'!\$AS\$154:\$AS\$256,2)``

Thanks for replying. I am doing a little more homework on this, and it appears as though I may be asking too much of excel to have multiple series of multiple lengths on the same chart. Could that have something to do with my problem?

#### Hoozits

##### Active Member
Here is the third

Code:
``=SERIES("LNKD P/E ratio relative to an index (left axis)",'DATA-Index'!\$A\$227:\$A\$256,'DATA-Internet'!\$BW\$227:\$BW\$256,1)``

#### Andrew Poulsom

##### MrExcel MVP
You can have two x axes as well as two y axes. What's the formula for Series 1?

#### Hoozits

##### Active Member
You have all 3 now. It appears as though when I plot series where two are of one length and the other is of a different length on two x axis and two y axis, then I am okay. Where I run into trouble is when I have 3 series, all of different length, the chart seems to break down. It's almost like excel would need a third x axis in order to do that, but I am a little green when it comes to charting in excel, so I am unsure if this is a true limitation or if there is something else I need to do.

#### Andrew Poulsom

##### MrExcel MVP
How are you creating the Chart?

#### Hoozits

##### Active Member
That is a tougher question. Someone else created the chart. Looks like it is a saved template. I was just asked to write code to populate the chart when certain parameters were entered into certain cells.

#### Andrew Poulsom

##### MrExcel MVP
Maybe Series 3 is on the wrong x axis.

#### Hoozits

##### Active Member
It appears as though some chart types handle my situation better than others. For instance, I have the best luck when I chart the series as an XY Scatter. Could that possibly have anything to do with it?

Last edited:

Replies
0
Views
240
Replies
1
Views
347
Replies
3
Views
667
Replies
4
Views
894
Replies
5
Views
2K

1,191,690
Messages
5,988,037
Members
440,125
Latest member
vincentchu2369

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back