Same label on both the axis in charts

ramaswamyrmm · #1 09-08-2008, 03:59 AM

I have a special reqirement, my vertical axix ( y axis) on either ends should carry the same label for example price (with intervals) for a stock market. can anybody help.

**Andy Pope** · #2 09-08-2008, 05:02 AM

In order to create 2 yaxis you require a minimum of 2 data series.
1 of the data series can then be placed on the secondary value axis, which will then allow you to display values for that axis.

Note that both series do not need to be displayed. One series can be formatted to have no line or markers.

ramaswamyrmm · #3 09-08-2008, 08:33 AM

Andy, I have tried to place the same values on both y axis, I think i have been fairly sucessful, but only thing is that sometimes the values or labels are not in syng with the grid lines aligned with the primary axis.

Method:
1. right click on the data series in the chart.
2.click on format data series.
3.click on axis tab.
4.choose secondary axis.
5.format axis as you have formatted the primay axis.

If you can give me solution as to how to correct the out of sync, it should be of help.

I am attaching one of the charts as an example.

thanks,
Ramaswamy.

**Andy Pope** · #4 09-08-2008, 08:40 AM

The gridlines in your example appear to be in sync.
How do you make them appear out of sync?

Why not base both series on the same data set?

ramaswamyrmm · #5 09-08-2008, 08:47 AM

At times it happens, I have some charts which ars so, I am unable to locate them, I shall search and forward them .

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Axis Label from Multiple Selections	slide	Excel Charting	1	07-31-2008 03:48 PM
Selecting Fixed X axis and 4 other Y axis to be plotted in 4 separate Charts not one?	uaeXuae	Excel Charting	0	12-08-2007 06:14 PM
Concatenating a label on x axis on Line Graph	ChemistB	Excel Charting	0	04-04-2007 05:51 PM
How to move Category (X) Axis Label	carstowal	Excel Charting	1	03-08-2007 07:34 PM
Going insane!	kik	Excel - New Users	10	01-31-2007 08:21 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)