Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axis on both sides?? Gridlines priority??
Is it possible to display a y-axis on both sides of a chart? Both should be identical, and should have automatic scales. It's on a Area chart with four or five data series. Alternatively, if I could give the Gridlines priority (ie if they appeared on top of the coloured area ranges) it would solve my problem. Thanks -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=542920 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axis on both sides?? Gridlines priority??
In place of gridlines use horizontal lines that you make yourself
Make them the same colour as the gridlines and they appear to extent to the edges of the plot area See http://peltiertech.com/Excel/Charts/...orzSeries.html -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "germullen" wrote in message ... Is it possible to display a y-axis on both sides of a chart? Both should be identical, and should have automatic scales. It's on a Area chart with four or five data series. Alternatively, if I could give the Gridlines priority (ie if they appeared on top of the coloured area ranges) it would solve my problem. Thanks -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=542920 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y-axis on both sides?? Gridlines priority??
Thanks, I think I can make that work.. -- germullen ------------------------------------------------------------------------ germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626 View this thread: http://www.excelforum.com/showthread...hreadid=542920 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display value axis on both sides | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
How do I add gridlines on a graph? | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel |