Closed Thread
Results 1 to 4 of 4

3D Bar chart xyz?

  1. #1
    Registered User
    Join Date
    04-03-2010
    Location
    Groningen, NL
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question 3D Bar chart xyz?

    hi I am trying to make a 3D Bar graph in excel 2007 with xyz values I have the following data as an example:


    x|y|z
    1|1|1
    1|2|2
    1|3|1
    2|1|2
    2|2|3
    2|3|2
    3|1|1
    3|2|2
    3|3|1

    I want the x column to be horizontal, the y column to represent the depth of the graph and the z value for the height of the bars. This data should give a 3x3x3 cube.

    Is this possible?
    I have seen them elsewhere in scientific journals.

    Many thanks

    Gary

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,444

    Re: 3D Bar chart xyz?

    You need to change your data layout.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-22-2010
    Location
    HongKong
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: 3D Bar chart xyz?

    Hi Andy,

    may i know how to do such result ?

    thanks

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: 3D Bar chart xyz?

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1