Chart question

Riga

New Member
Joined
Oct 20, 2002
Messages
2
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:
Line=lake level reading by date
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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
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
Joined
Feb 10, 2002
Messages
11,654
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".
 

Forum statistics

Threads
1,144,050
Messages
5,722,231
Members
422,417
Latest member
Johhny

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top