"Ranges" in charts



This is the chart I have made so far:

http://www.mattloaf1.com/chart1.jpg

It is used to track the scores of employees on a personality test, and
is broken down into several categories. Each category has an
acceptable range of scores, indicated by the bar chart (the visible
portion is the 2nd part of a 'stacked' bar chart.. I made the first
part invisible so it appears that the 2nd part is floating). This
range I have indicated is the old acceptable range... I also wish to
show a new acceptable range on top of this old range. In some cases,
the old and new ranges overlap. However hard I've tried, I have not
been able to get these two ranges to show up together, either on top of
each other or directly next to each other. Any suggestions on how I
might achieve this?

Thanks in advance for your help.

.



Relevant Pages

  • Re: How can I combine a stacked bar chart with stacked colum chart
    ... The range L1:P241 is plotted in a stacked column chart in Stephen's example, ... or in a stacked bar chart in yours. ... >> Jon Peltier, Microsoft Excel MVP ... >> Peltier Technical Services ...
    (microsoft.public.excel.charting)
  • Re: How can I combine a stacked bar chart with stacked colum chart
    ... > or in a stacked bar chart in yours. ... > Jon Peltier, Microsoft Excel MVP ... >>> Peltier Technical Services ...
    (microsoft.public.excel.charting)
  • RE: sort bar chart in excel
    ... D2 as a single cell array (do so by pressing Control-Shift-Enter at the same ... items that you needed to chart, chnage the 10 in the formulas to 20. ... Base your bar chart on the second range of data. ...
    (microsoft.public.excel.charting)
  • RE: sort bar chart in excel
    ... D2 as a single cell array (do so by pressing Control-Shift-Enter at the same ... items that you needed to chart, chnage the 10 in the formulas to 20. ... Base your bar chart on the second range of data. ...
    (microsoft.public.excel.charting)
  • HELP PLEASE modifying chart properties at runtime
    ... We first would like to change the height of our bar chart based on the ... Dim report1 As New CrystalReport9a ... Dim crxSubReport As craxdrt.Report ...
    (microsoft.public.vb.crystal)