Archive of Mr Excel Message Board
|Check out our Excel Charting Resources
Back to Charting for Excel archive indexBack to archive home
Excel chart with 3 variablesPosted by Kris on February 06, 2001 1:04 PM
How do you set up the data for a 3 variable chart - is it possible to do? These are the variables,
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?
Re: Excel chart with 3 variablesPosted by Kurt on February 07, 2001 10:00 AM
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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.