Graphs using 2 very different scales

billwcsi

New Member
Joined
Mar 17, 2002
Messages
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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

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
Back
Top