# line chart

#### tmnorge

##### New Member
I have a line chart, with two series.

When i use two axis, by double clicking on one serie, then on axis label, choosing Plot series in : "Secondary Axis"

My chart looks like :

But now, if i choose (for the FF serie) "Primary Axis", i get :

You can see that the data has been fitted to the ED serie, but the left axis does not correspond to the values of FF serie.
My question is : what is the transformation of data used to fit the other serie ? I just checked that it is not a linear rescalling, so i really don't know what Excel did compute to have such a good fitting of data (actually I want to use the FF serie to predict the ED one, so it could be of very great help to find the answer...)

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### venkat1926

##### Well-known Member
suggestion from top of the head

if you make FF series as primary axis change the other seris ED to secondary axis and see.

#### tusharm

##### MrExcel MVP
By default XL does not make any kind of transformation based on the axis you selected.

There is something more going on here. Before you moved FF to the secondary axis, what did the chart look like? Also, are you sure that in the 2nd image you have the same 2 series? It doesn't look like that. In the 1st image the first 2 changes in FF are increases. In the 2nd, the initial change is a drop.

{snip}You can see that the data has been fitted to the ED serie, but the left axis does not correspond to the values of FF serie.
My question is : what is the transformation of data used to fit the other serie ? I just checked that it is not a linear rescalling, so i really don't know what Excel did compute to have such a good fitting of data (actually I want to use the FF serie to predict the ED one, so it could be of very great help to find the answer...)

#### tmnorge

##### New Member
Yes, you're right it happens that it is not the same two series : after many hours of investigation, i saw that the line chart i used was "stacked line". So Excel was addind the two series in "FF". Because FF was lower than ED, the sum was very near from ED, that's why i thought Excel was transforming data....

Thank you !

Replies
4
Views
138
Replies
6
Views
180
Replies
7
Views
111
Replies
1
Views
1K
Replies
2
Views
229

1,172,100
Messages
5,879,141
Members
433,398
Latest member
edu1102

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