View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 2 Horizinotal axes in Excel 2007

Hi,

You need to use the Select Data dialog to specify alternative x axis ranges

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tigerxxx" wrote in message
...
Hello,
I have ploted two series of data on two vertical axes in Excel 2007.
Hence currently excel offers me seetings for 2 vertical axes and 2
horizontal axes.
However, I am unable to select different sets of data for each of the
horizontal axes i.e. I want to display two "X" axes displaying two
different
tset tof ranges.

Please advise how I can select 2 horizontal axes pointing to two different
data sets.

Thank you