I Need Some Help On Ms Excel - Charting. Any Professionals Itu Randi.

[kidmakers]

konchem urgent guys.. i can post if anyone is able to help.

[kidmakers]

ok. please try to help me guys.. i am searching all across google and excel forums for this. this seems to be simple, but i am not able to figure out how to do it

1. There is a candlestick chart in a range of x-axis : 1 to 60 y - axis : 4800 - 5700
2. Another chart , simple line chart x- axis: 1 to 60 y - axis : -100 to +100


I want to overlay these two on a single chart. i will post the screen shots also. but pls clarify me. its very important for me.

[kidmakers]

somebody try to help, i ll post the screensohts in a while when i come back.

[anbe__shivam]

LTT

[kiraaaak]

LTT help

[kidmakers]

Guys .. question again

1. two data columns

column 1: 60 data points, data range from 4800 - 5700
column 2: 60 data points, data range -100 to +100
.

two columns on a single chart (means two line graphs)

kontha mandhi chestaru x-axis same ainappudu left side oka y axis and right side oka y axis values tho, two line graphs ni plot chestaru. i dont know how to do it. its a bit urgent and i am flooded with work, so could nt really do much googling. pls help if anyone can. thanks in advance.

[padmasri123]

LTT

[pikki]

[chelsea]

ltt

[kidmakers]

[IMG]http://i46.tinypic.com/x5sf2q.png[/IMG]

in the above pic, there are two charts. top one corresponding to column E

bottom one corresponding to column J

Can i plot them both on the same chart, with two y axes and one x axis ?.

[_poori]

Step 1: Select the two columns which need to be plotted on the line graph
Step 2: Insert a line graph with the two data columns in Y-Axis and the corresponding column that needs to be in the X-axis
Step 3: Now you will have a line graph with the two data columns plotted against the same series. Select the line in the graph which needs to be in the secondary axis and right-click and select "Format Data Series"
Step 4: In the pop-up that opens, select "Series Options" on the left side and select "Secondary Axis" and click OK.

ee instructions Office 2007 kosam.. other version of Office lo kuda almost same steps untayi anukunta

[kidmakers]

awesome.. thank u very much poori.