Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Horizinotal axes in Excel 2007
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Horizinotal axes in Excel 2007
Hi Andy,
When I go to select the data, I only see one data selection option for the X axis. How can I select the data for the secondary X axis? Please advise. "Andy Pope" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Horizinotal axes in Excel 2007
Hi,
Unlike xl2003 which displayed Primary and Secondary range selectors xl2007 only displays 1. The one displayed is for the series selected in the Legend Entries (Series) list. To begin with they will both point to the same range and therefore display the same information. Select the series that is on the secondary axis and then use the Edit button for the Horizontal (Category) Axis labels. Once set to a different range you will more easily see that the series are using different information when selecting them in the list. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tigerxxx" wrote in message ... Hi Andy, When I go to select the data, I only see one data selection option for the X axis. How can I select the data for the secondary X axis? Please advise. "Andy Pope" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Horizinotal axes in Excel 2007
Thanks a lot...I believe this works!
"Andy Pope" wrote: Hi, Unlike xl2003 which displayed Primary and Secondary range selectors xl2007 only displays 1. The one displayed is for the series selected in the Legend Entries (Series) list. To begin with they will both point to the same range and therefore display the same information. Select the series that is on the secondary axis and then use the Edit button for the Horizontal (Category) Axis labels. Once set to a different range you will more easily see that the series are using different information when selecting them in the list. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tigerxxx" wrote in message ... Hi Andy, When I go to select the data, I only see one data selection option for the X axis. How can I select the data for the secondary X axis? Please advise. "Andy Pope" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Bar and Line chart on 2 Axes | Charts and Charting in Excel | |||
Date axes in Excel 2003 and 2007 | Charts and Charting in Excel | |||
Excel 2007-Lines on 2 Axes | Charts and Charting in Excel | |||
Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
Show 'incomplete' axes & show ticks but NOT axes? | Charts and Charting in Excel |