Two different x axis scales on same chart

**Beeblebrox** · 11-15-2006, 03:16 PM

Is there a way to have two separate X axis scales on the same chart. I have one set of data ranging from 1,000 to 5,000 and another set ranging from 100,000 to 500,000. I'd like to have one set on the left x-axis and the other on the right x-axis ending up with two separate lines graphed.

**Bryan Hessey** · 11-15-2006, 03:29 PM

Originally Posted by Beeblebrox

Is there a way to have two separate X axis scales on the same chart. I have one set of data ranging from 1,000 to 5,000 and another set ranging from 100,000 to 500,000. I'd like to have one set on the left x-axis and the other on the right x-axis ending up with two separate lines graphed.

Hi,

rightmouse on the data line for the Format Data Series menu, and set to Primary or Secondary axis

hth
---

**jmaya** · 11-16-2006, 07:25 AM

Hi
Bryan is right about his reply, but I should mention that he is referring to plotting two sets of data against two y-axes, left and right. You can also plot data on two x-axes, top and bottom. Add the additional axis from the axis tab in chart options menu.

**Bryan Hessey** · 11-16-2006, 07:54 AM

Originally Posted by jmaya

Hi
Bryan is right about his reply, but I should mention that he is referring to plotting two sets of data against two y-axes, left and right. You can also plot data on two x-axes, top and bottom. Add the additional axis from the axis tab in chart options menu.

Hi,

True, but with the reference to 'x axis' and 'left and right' I presumed that the 'left and right' had a better chance of being correct.

---