If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to have the Y-axis values on both sides
I am working with a chart that where I would like the Y-
axis to be on both "ends" of the chart (right and left). If that is not possible I would like the y-axis values to be on the right side, instead of the usual left side. Anyone knows how I can do this? |
#2
|
|||
|
|||
How to have the Y-axis values on both sides
Hi Peter,
To get the y-axis on the right select the x-axis and on the scale tab of the format dialog check the 'Value (Y) axis crosses at maximum category' option. To get two sets of y-axes you will need to add a dummy data series and move it to the secondary axis. If you use the original data in the dummy series then the min/max values of the second scale should match the primary. You will also need to format the dummy series, no border and no fill. Also delete the legend entry. Peter wrote: I am working with a chart that where I would like the Y- axis to be on both "ends" of the chart (right and left). If that is not possible I would like the y-axis values to be on the right side, instead of the usual left side. Anyone knows how I can do this? -- Cheers Andy http://www.andypope.info |
#3
|
|||
|
|||
How to have the Y-axis values on both sides
On Thu, 23 Oct 2003 00:52:00 -0700, Peter =
wrote: I am working with a chart that where I would like the Y- axis to be on both "ends" of the chart (right and left). If that is not possible I would like the y-axis values to be on the right side, instead of the usual left side. If you have more than one series, you can select one series and go to = Format | Selected data series | Axis tab and select secondary axis. You= = will get a right and left y-axis. If you want only a right-side y-axis, select the x-axis (*not* the y-axi= s) = and go to Format | Selected axis | Scale tab and select "Value (y) axis = crosses at maximum value." If you have only one series and you want two y-axes, you'll have to use = a = dummy series, chart it against the secondary axis (as described above), = and format it as invisible. -- = Dave dvt at psu dot edu |
#4
|
|||
|
|||
How to have the Y-axis values on both sides
As an alternative, you can use my Arbitrary Axis technique to construct
a spare axis: http://www.geocities.com/jonpeltier/...s.html#ArbAxis - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Peter wrote: I am working with a chart that where I would like the Y- axis to be on both "ends" of the chart (right and left). If that is not possible I would like the y-axis values to be on the right side, instead of the usual left side. Anyone knows how I can do this? |
Thread Tools | |
Display Modes | |
|
|