Seriation Graphs

[schmoikel]

Hello to all,

I'm currently struggling with Excel 2007 and I need to produce a seriation graph. I've searched the web and did a search here and no luck.

Is it even possible to graph data using the a seriation graph in Excel?
If so, How?

Thanks in advance,
Schmoikel

[shg]

Welcome to the forum.

Post some data, and we'll both have a learning experience.

[schmoikel]

Thanks for the welcome.

I've attached a sample excel file with some data.
The seriation graph that you see on the right hand side is 'fake'. I just made some rectangles based on the numbers and sized them accordingly.

I'm not even sure if Excel can make such a graph but if it's possible, I'm sure the people here can figure it out.

[shg]

So, some explanation of the data in columns B/C/D?

[shg]

Like this?

[schmoikel]

The seriation graph is used in archaeology to date an artifact. For example, by looking at the telephone we can see how much it has changed from it's humble beginnings to the present. If we didn't have any actual dates, we could still infer a timeline.

The data in the sample shows grave markers and the 'art' that was depicted on them. The numbers in columns B,C, and D are the totals found. The Death's Head was the earliest, followed by the Cherub, and finally the Willow. You never see any willows at the same time of the Death's Head.
The bars show a representation of the numbers.

Not sure if that cleared things up.

[shg]

Did you see the workbook I posted?

[schmoikel]

Did you see the workbook I posted?

Wow, now the Million Dollar Question.

How did you do it?
____________________

Wait, I think I see how you did it.
=REPT(Block, B9)

I have no idea what REPT is or Block but if I'm looking at it right, that's what you did.

Fantastic!!! I knew I came to the right place!
Thanks a TON!

[shg]

REPT is a function you can find in Help.

Block is a name I created to refer to the Full Block character, which I got from Insert Symbol. Look in Insert > Name > Define.

I think the presentation on the right of this attachment conveys better.

If you're good to go, would you please the thread as solved?
---------------------------------------------------------------

To mark a thread as solved:

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

If more than two days have elapsed since your first post, ask a moderator to mark it.

[samkhan]

hey!

can you please explain how you made the graph? i did my own research based on the death/cherub and urn research by james deertz, now i need hepling showing my results!

appreciate the help! thank you


Sam

[samkhan]

can you please explain how you made the chart ?

[shg]

It uses simple formulas, all shown, that use the the raw data directly as arguments.

[MrShorty]

I might suggest this explanation of in cell charting: http://peltiertech.com/Excel/Charts/...ulaCharts.html