• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Execel make isometric graph? See picture

B

BigD

Member
I drew the attached picture in Excel; however, I was curious if Excel had the option to construct such graph from data.

Thank you
 

Attachments

  • graph.jpg
    graph.jpg
    73.8 KB · Views: 21
BigD

Yes, But it will be a modified Scatter Chart

Can you post a set of data you would like to see and a sample chart
 
Hi Hui,

Thank you for the prompt reply. Here is my data:

One graph (current): Quadrant I: 34.3 ; Quadrant II: 14 ; Quadrant III: 22.8 Quadrant IV: 29.2


One graph (future): Quadrant I: 27.8 ; Quadrant II: 6.7 ; Quadrant III: 30.8 Quadrant IV: 34.7

All the graph is basically a normal axis grahy (x and y) rotated so the plots will be each quadrant. The sample chart the picture I posted above.

Thank you again,

Cheers
 
Hui,

This worked out amazing. Is there any way to show the (-) numbers as positive on the axis? I understand you have to use the negatives to plot them all, but is there anyway to not show the (-) sign?

Thank you again for the help. It was a life saver.

Dustin
 
Hi Dustin ,

In your worksheet , select the range of values in B15:B32 , and put in the custom format #0;#0

This displays the negative values without the minus "-" sign.

Narayan
 
This worked exactly how I asked; however, it is not taking the "-" signs off the graph. I changed F15:F32 and the negatives signs still appear on the graph.

Thank you for the input though.

I hope all is well. I have a possible project coming up modifying our scheduling spreadsheets that I may reach out to you for help.

Thanks again,

Dustin
 
Last edited:
You must log in or register to reply here.
Back
Top