Need Help making a 3D graph

[Raul7]

Hi Guys,
Need help building a graph, here is my sample Data

NAME | Region
Joe | WEST
Joe | WEST
Joe | EAST
Bill | EAST
Bill | EUROPE
Bill | Mid-West


now I want a Graph that would show the total number on the Y axis and each Name on the X , for example JOE would should the bar rise to 3, while inside the bar, WEST is shown as blue colour (2) and East with Orange colour (1) and so on.

I appreciate your time and help.

 

[Raul7]

Anyone can help me please?

 

[thisoldman]

Hi Raul7,

One reason people may hesitate with replies is that you request a 3D chart. 3D charts will often distort data. People have sometimes deliberately used this distortion to give an inaccurate picture of the data. For many of us, when we see a 3D chart, we ask, "What are they trying to hide?" or, more bluntly, "Are they trying to lie?" Please don't use a 3D chart.

Graphs are a way to visualize numbers. You want to show the count of how many times "West" appears under Bill's name, how many times "East" occurs, and so on. You have to do the counts.

When I do the counts of the data you posted, I come up with a table like this:

[TABLE="class: grid"]
<tbody>[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: center"]A[/TD]
[TD="class: xl63, width: 64, align: center"]B[/TD]
[TD="class: xl63, width: 64, align: center"]C[/TD]
[TD="class: xl63, width: 64, align: center"]D[/TD]
[TD="class: xl63, width: 64, align: center"]E[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]West[/TD]
[TD="class: xl63"]East[/TD]
[TD="class: xl63"]Europe[/TD]
[TD="class: xl63"]Mid-West[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63"]Joe[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63"]Bill[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

These instructions are for Excel 2013 and later.

Select all the cells in the table, here it's cells A1:E3. On the ribbon, select "Insert". Then select the icon for "Insert Column or Bar Chart". Select one of the stacked column or bar chart variations in the menu that pops up. The stacked columns and bars are in the second column from the left. Don't worry if the preview doesn't look like what you want.

After you have made your selection, the chart will be inserted into the worksheet. There will be small circles on the borders of the chart—these tell you the chart has been selected. A new group of tabs, "Chart Tools" will appear on the ribbon.

The chart may not display the data sorted and stacked the way you want to show it. If that is so, with the chart still selected, click on "Design". Then click "Switch Row/Column". That should fix things up.

I hope this helps you.

 

[Raul7]

Thank you very much for your help.