Combining a Bell Curve and another chart type

A

andream02

Board Regular
Joined
Jul 26, 2007
Messages
70
Help! I have created a bell curve that shows me payment distribution for our sales force compensation. The bell curve works beautifully, however, I would also like to show in this same chart the budgeted average as well as the actual average. I am currently using the rectangle shape in the drawing toolbar to manually input the bars that represent these two data points. I was wondering if there is any way to have excel automatically chart these along with my bell curve.

I have an example that I can send if that helps.

Thanks!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
You can add the two new series to your graph, then select each in turn, right-click and choose "Chart Type" from the menu, then choose "Line". This will change only the chosen series, not the whole chart. You will then have one set of bars and two superimposed lines, all at the same scale. Is this what you're trying to achieve?
 
Upvote 0
Ideally this is what I would like to do, however, I am using a "Line - Column on 2 Axes" chart and it will not allow me to insert additional series. With this chart type, I am only able to use the rectangle shape in the drawing toolbar to manually input the bars that represent these two data points.

I've included a link of what I am trying to create without having to do so manually.
http://www.flickr.com/photos/33225803@N05/3098130081/

Please let me know your thoughts.

Thanks!
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
Automated Draw Schedule
Replies
1
Views
166
Hydestone
H
S
  • Question
Bubble Chart - 5 variables including 2 "combined"
Replies
0
Views
672
shooterznednol
S
H
  • Question
Performance with Static Bell Curve
Replies
0
Views
210
hmltnangel
H
E
  • Question
Bell curves for housing prices
Replies
1
Views
1K
mole999
mole999
W
  • Question
Scatter Chart? Bell Curve?
Replies
5
Views
2K
wingingit2018
W

Forum statistics

Threads
1,215,219
Messages
6,123,689
Members
449,117
Latest member
Aaagu

Share this page

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