kwarden13
asked on
Excel Graph Best Way
What is the best way to graphically represent the following fields
Location Profit Capacity Utilization
I thought a 3d scatter plot but Im not sure if that is best.
Location Profit Capacity Utilization
I thought a 3d scatter plot but Im not sure if that is best.
ASKER
Heres some sample data
Location Capacity Profit Utilization
H20 602,740 11.43 91.76%
H21 1,513,092 14.09 70.44%
H22 810,458 11.97 61.61%
H23 316,599 5.77 72.45%
H24 591,245 7.86 74.77%
H25 220,506 17.47 85.27%
H26 1,150,294 14.54 75.60%
H27 853,176 5.06 26.93%
H28 708,678 8.47 69.06%
H29 224,228 17.05 46.38%
H30 690,776 3.94 44.72%
Location Capacity Profit Utilization
H20 602,740 11.43 91.76%
H21 1,513,092 14.09 70.44%
H22 810,458 11.97 61.61%
H23 316,599 5.77 72.45%
H24 591,245 7.86 74.77%
H25 220,506 17.47 85.27%
H26 1,150,294 14.54 75.60%
H27 853,176 5.06 26.93%
H28 708,678 8.47 69.06%
H29 224,228 17.05 46.38%
H30 690,776 3.94 44.72%
OK, and what is it that you're trying to "say" with these data?
Before you go any further, be aware that Excel allows a maximum of two Y axes. So, if you're using Location as the X axis, you're out of luck showing the other three fields as Y axes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's a great suggestion, rorya!!
As an added benefit of this approach, you can use the AutoFilter on the data table to sort the data ( select any cell in the data table and hit Alt-D-F-F to enable Autofilter (works in any Excel version) or in 2007 or later click Data > Filter [ in Excel 2003 or earlier click Data > Filter > Auto Filter)
Each column will now show a drop down in the header row, which you can use to sort the data, i.e. by capacity, profit or utilisation and the charts will update accordingly, providing you with a suitable focus for your analysis.
points to rorya
cheers, teylyn
As an added benefit of this approach, you can use the AutoFilter on the data table to sort the data ( select any cell in the data table and hit Alt-D-F-F to enable Autofilter (works in any Excel version) or in 2007 or later click Data > Filter [ in Excel 2003 or earlier click Data > Filter > Auto Filter)
Each column will now show a drop down in the header row, which you can use to sort the data, i.e. by capacity, profit or utilisation and the charts will update accordingly, providing you with a suitable focus for your analysis.
points to rorya
cheers, teylyn
Here's a good way to illustrate all the data in one chart:
Panel Charts with Different Scales
It takes a little work, but it's worth it.
Panel Charts with Different Scales
It takes a little work, but it's worth it.
There is not enough info to answer your question.
1) What are you trying to demonstrate with the data? What story are you trying to tell?
2) What would typical sample data look like?
One thing I can say: don't use 3-d charts. Ever. Seriously :)
Patrick