Graphs using 2 very different scales

billwcsi · Mar 18th, 2002, 01:46 PM

I want to graphs "# of apps." and "Premium $" on the same graph in a trend format. My # of apps will be between 1000-2000 each month while my "Premium $" will be between $1,000,000 and $2,000,000 each month. Is there a way to place this data together in a line graph where the scale for the "apps" will be on the lefthand side and the scale for the "Premium$" would be on the right hand side? Please help if you can.
Thanks,
billwcsi

Steve Hartman · Mar 18th, 2002, 01:59 PM

Plot your two series like a normal graph.
right click one of the data series in the graph and choose Format Data Series. Choose Axis Tab and check plot on secondary axis. format as needed

[ This Message was edited by: Steve Hartman on 2002-03-18 13:22 ]

Mark W. · Mar 18th, 2002, 03:14 PM

Alternately, while creating your chart at Step 1 of 4 in the Chart Wizard click on the "Custom Types" tab, scroll down the list of chart types, and choose the "Lines on 2 Axes" entry. Note: Don't be fooled by the graphic (line-column chart) displayed next to this selection -- this is really (and exclusively) a line chart.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 01:46 PM	#1
billwcsi New Member Join Date: Mar 2002 Posts: 12	I want to graphs "# of apps." and "Premium $" on the same graph in a trend format. My # of apps will be between 1000-2000 each month while my "Premium $" will be between $1,000,000 and $2,000,000 each month. Is there a way to place this data together in a line graph where the scale for the "apps" will be on the lefthand side and the scale for the "Premium$" would be on the right hand side? Please help if you can. Thanks, billwcsi

Mar 18th, 2002, 01:59 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Plot your two series like a normal graph. right click one of the data series in the graph and choose Format Data Series. Choose Axis Tab and check plot on secondary axis. format as needed [ This Message was edited by: Steve Hartman on 2002-03-18 13:22 ]

Mar 18th, 2002, 03:14 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Alternately, while creating your chart at Step 1 of 4 in the Chart Wizard click on the "Custom Types" tab, scroll down the list of chart types, and choose the "Lines on 2 Axes" entry. Note: Don't be fooled by the graphic (line-column chart) displayed next to this selection -- this is really (and exclusively) a line chart.