PDA

View Full Version : [SOLVED] 3D Z-Axis



justdream
08-20-2014, 02:02 AM
Dears,

Kindly help me to use below sheet Raw Data to get same 3D Z-Axis shown chart
where:
Index0 to index39 "x-axis"
Flag1 (Blue & red) "Z-axis"
Sum of Index of each color is "Y-axis"
and Time & name are my filters

Aflatoon
08-20-2014, 02:53 AM
Why do you want a 3D chart? It looks terrible and is harder to read. Just use a clustered column chart.

justdream
08-20-2014, 02:56 AM
mm, Could you guide me how to do

justdream
08-20-2014, 03:15 AM
Aah, you mean normal columns, I'd like to learn how display both Red & Blue columns together as shown above

Aflatoon
08-20-2014, 03:22 AM
You'll have to summarize your data first since you have multiple rows for Blue and for Red. You could use a pivot table for that and then just choose the relevant chart type. You'll probably need to alter the rotation to make it match your picture. It's still a truly awful chart though.

justdream
08-20-2014, 03:26 AM
Nice, I did that (Pivot & Rotation) but I didn't succeed to get Blue & RED columns in Z axis "parallel to each other"

Aflatoon
08-20-2014, 03:46 AM
It would help to see what you did - can you post the workbook?

justdream
08-20-2014, 03:52 AM
Here it's
instead of having Blue & Red in series
I'd like to display in Parallel

Aflatoon
08-20-2014, 05:26 AM
You used the wrong chart type - you want the 3D column (last one), not 3D clustered column.