Excel chart with two x-axes

[englishmustard]

I would like to draw a chart with one y-axis and two x-axes. Please can someone point me in the right direction?

[Bernard Liengme]

1) Make chart with two data series
2) Double click one series in chart to open Format Data Series dialog
3) Open Axis tab and check the Secondary Axis box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"englishmustard"
<[email protected]> wrote in
message news:[email protected]...
>
> I would like to draw a chart with one y-axis and two x-axes. Please can
> someone point me in the right direction?
>
>
>
>
> --
> englishmustard
> ------------------------------------------------------------------------
> englishmustard's Profile:
> http://www.excelforum.com/member.php...o&userid=31804
> View this thread: http://www.excelforum.com/showthread...hreadid=571679
>

[Andy Pope]

Just to add the final steps to Bernard's instructions in order to get
the secondary X axis to show.

Right click the chart and pick Chart Options.
On the Axes tab check secondary x axis.

http://www.andypope.info/tips/tip008.htm

Cheers
Andy

Bernard Liengme wrote:
> 1) Make chart with two data series
> 2) Double click one series in chart to open Format Data Series dialog
> 3) Open Axis tab and check the Secondary Axis box
> best wishes

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

[englishmustard]

Thank you!

/Rog.