View original (French)

Excel 2007, no secondary axis

Tinah -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,

I would like to represent a histogram with two horizontal axes. However, my Excel 2007 in the 'series options' does not display the option "Plot Series On". How can I get the "Secondary Axis" option to appear?
Thank you

Configuration: Windows XP / Firefox 3.5.16

4 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    The method with XL2003 is as follows:
    Add a data series (it can be the same as series 1)
    Right-click on series 2 --> chart type --> line
    Right-click on series 2 --> Format --> select axis --> secondary axis
    Left-click to select the chart area (not the plot area) right-click --> chart options --> check secondary X-axis
    To make series 2 invisible without deleting it Click --> format --> pattern --> check no line and no marker.
    It's up to you to negotiate the small variations between XL2003 and XL2007.
    5
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Hello Tinah.

    1) There is no secondary horizontal axis.

    2) To obtain a secondary vertical axis, you need at least 2 data series with the same abscissas. Hence the tontong procedure ...
    --
    Retirement is nice! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
  3. Tinah
     
    Thank you for the response in XL2003.
    Sure, I would like to talk about the secondary vertical axis. However, my Excel 2007 does not display the "secondary axis" box in 3D mode when I want to represent a histogram with 2 series with 2 secondary axes.
    Thank you.
    0
    1. Tinah
       
      with 2 vertical axes instead.
      0
    2. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
       
      Hello,
      I'm afraid it may not be possible to add a secondary y-axis to a 3D histogram.
      To simply summarize: 3 axes in 3D: x, y, z.
      3 axes in 2D: x, y1, y2.
      0
  4. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Yes, Tinah; it is indeed necessary to be pragmatic, precise, and thorough when presenting a problem:

    "I would like to represent a histogram with two horizontal axes" has 2 major differences compared to
    "I would like to represent a 3D histogram with two vertical axes".

    You would have been told right from the first response that secondary axes are only available on 2D charts... tontong has nicely summarized the situation above.
    --
    Retirement is nice! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0