Hello,

Sorry up front, this is kinda large.

I am having an issue with making the 3D lateral bar graph display the info I am needing.

I am making a graph based off of product issues, 5 most common tickets, and form there, the 5 most common part numbers and their volume of issues.  So 5 sections of 5 issues.  I get an overview of the 5 main issues, then I get the top 5 instances.

Below is the example of the dataset, B1:D5 is the overview, which makes up the side headings, and B7:E35 make up the body of data.  All of column A is basic  things of for example A8-10 are simple cells of =C1   =B1   =D1.

Now the next pic is obviously not a graph, but it is the basic end result I am looking for.

So far when I try to make the graph, each of the colored bars come out as 2 bars 1 showing the proper length, and one showing as a reference.  The text is not in the bar either.  And for some reason, all of the date is sorted backwards, I just gave it basic criteria and it reversed all of the headings, counted top down lowest to highest, and that is not how it is organized.

I am well aware that this is a bit much to ask, and I apologize in advance.  I won't bore anyone with my jobs specifics, but I am coming here to LEARN how to do it, rather than use one of those automated things  as a download that will do it FOR ME, as I really prefer to learn rather than download a fix  :)

Thanks all!

Dave

Hi,

Is that you want to insert 3D column to show the data in Excel?

Check to see the following picture:

For more information, please refer to the following link:

http://office.microsoft.com/en-in/excel-help/present-your-data-in-a-bar-chart-HA010218664.aspx