PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting A Combination Chart using a Column and Line

Reply

A Combination Chart using a Column and Line

 
Thread Tools Rate Thread
Old 14-11-2007, 04:36 PM   #1
MountainMan
Guest
 
Posts: n/a
Default A Combination Chart using a Column and Line


I have a large amount of data about protein values and I have grouped these
using the Analysis-Pak Histogram wizard. The resulting frequencies have
been charted using the 'Column' Chart Type.

Using the NORMDIST function I then plotted the appropriate Normal Curve as a
'Line' Chart Type on the same chart but using a secondary y-axis.

I was wondering if there is any sensible way of scaling the NORMDIST values
so that both sets of data can be charted on the same axis.

Any suggestions will be gratefully received.



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off