Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
display value axis on both sides
I'm trying to display the y axis on both the left and right side of the
chart; is this possible, and if so, how to i go about it? thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
display value axis on both sides
This requires having a primary and secondary axis. The minimum requirement
here is to have two series. The best way to manage this is to add a range to the worksheet using, say, the first two X values for X, and the minimum and maximum values in all of your Y data for Y. Add this range to your chart as a new series. If your main chart is a column chart, change this series only to a line chart type (Chart menu Chart Type); otherwise use the same type as exists in the chart. Double click on this new series, and first, on the axis tab, choose Secondary. Then on the Patterns tab, hide the series by choosing None for line and marker. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "pault" wrote in message ... I'm trying to display the y axis on both the left and right side of the chart; is this possible, and if so, how to i go about it? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need 2 rows to display X axis data points for a line graph | Charts and Charting in Excel | |||
I have a problem to properly display the title of Value (Y) axis i | Charts and Charting in Excel | |||
category axis doesn't display values | Charts and Charting in Excel | |||
Exell graph cannot display the Y axis on my 16/10 notebook comput. | Charts and Charting in Excel | |||
Axis display as category | Charts and Charting in Excel |