Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007Back to Charting for Excel archive index
I want the data to all appear in the same chart. I was trying to use the column chart showing the 3 shifts in one column, but how do you do it with 3 variables?
I've only used a three variable chart when one of he variables relates to the other one in terms of magnitude. For instance:
Department Revenue Goals
%Probability of Department achieving goals
With the variables above you can have the departments on the X axis the revenue goals on the Y axis as circles and the probability represented by the size of the circles.
YOu can find this type of chart in the custom section of Charts in Excel.
Hope that helps.