3 way graph

[rctneil]

Hey,
A family member is addicted to playing Pocket Frogs on their iPhone.

In the game, the aim is to collect as many different types of frogs as possible.

Each frog has 3 characteristics:

1. A type
2. Colour 1
3. Colour 2

I want to make a sort of chat to allow them to mark off and quickly see what frogs she has.

This is really annoyingme, how can I make a chart to show this information when I have 3 attributes.

If I only had two I have an x and y axis but here I ahve x, y and z.

I'm sure there is a way of showing three attributes on 1 graph.

Thanks

Neil

 

[SiriusB]

And this is in the Windows forum because...?

The first idea that pops into my head is combine the colours into one attribute.

So say there are 3 possible colours for each Colour 1 and Colour 2: Red, Green, Blue

Instead of having

Type
Blue
Green

You could have

Type
Blue/Green

That could turn out to be a lot of combinations if there are a lot of colours though.

 

[manic_man]

3D Scatter plot

Glyph plot (x/y positions of each icon/glyph = 2 attributes, physical properties of each icon/glyph = 3rd attribute)

To name a few that you can do with Excel

 

[rctneil]

I know it's not strictly a Windows theme but put it in here as it could be done in Excel but didn't know HOW to do it in excel. I didn't mention excel incase people had other ideas.

@manic_man Could you let me know HOW to do that in Excel, how is the raw data meant to be laid out?

 

[manic_man]

sure,

I'm assuming you mean you have 3 dimensional data (note: this is not necessarily the same as 3 geometrical dimensions, it just effectively means you have 3 columns of data).

So, start by putting three headings in the first three cells along the top of the spreadsheet, then paste your data into their respective columns.

Now highlight all three, and assuming you have excel 2007 or later, try out the bubble plots, radar plots, surface plots, area plots and the 3D bar plots.

Effectively anything you can map more than 2 variables (where a column of data is a variable) to, and have a play around.

That is of course unless I have grossly misunderstood the type of data you wish to visualize

 

[SiriusB]

Would any of those chart types even be useful as a list. Because basically that's what he seems to want if it's a means to see which frogs his family member has.

If it is basically some kind of checklist you are after you could do the following:

So as you can see, rather than trying to fit it all in one chart, just break it down into individual tables for each type of frog. In the image above the number represents how many of each colour combination he/she has of a particular type. Blank square means they don't have that particular colour combo yet.