# Chart question

#### Riga

##### New Member
I would like to plot a lake level and corresponding precipitation on the same graph, and I'm pulling my hair out trying to figure out how.
Say I want to plot the following on 1 graph:
3/1/02 200.1 feet
3/10/02 200.5
3/12/02 200.7
3/15/02 200.8

Bar=daily precip by same date
3/1/02 0.2 inches
3/2/02 0
3/3/02 0
3/4/02 .3 in
3/5/02 0
3/6/02 0
3/7/02 .2 in
3/8/02 0
3/9/02 0
3/10/02 .2 in
3/11/02 0
3/12/02 0
3/13/02 0
3/14/02 .1 in
3/15/02 0

I can figure out how to graph each set independently, but not both on the same graph. Obviously the x-axes will be common, but I need different y-axes scales. Any help setting this up would be greatly appreciated.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Von Pookie

##### MrExcel MVP
I think this may be what you're looking for:

Select all of your data, then go to Insert|Chart (or click the chart button on the toolbar--doesn't matter).

For Chart Type, click the tab labeled "Custom Types" and select "Line-Column on 2 axes" and click next.

From there, just go through and check that your series names, etc. are how you want them.

Hope it helps,

#### Mark W.

##### MrExcel MVP
Plot one of the 2 series, then Copy the 2nd and Paste Special... New Series.

See the Excel Help topic for "Plot a data series along a secondary value axis in a 2-D chart".

#### Riga

##### New Member
Got it now. Thanks a ton for the help.

R

Replies
3
Views
339
Replies
2
Views
342
Replies
1
Views
425
Replies
1
Views
979
Replies
1
Views
233

1,181,104
Messages
5,928,093
Members
436,587
Latest member
Slicesofquince

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back