Bar chart Battlefield Chart

[dariushou]

Hi All, i'm sorry to bother you, but i just can't figure this out. I figured such a chart would be somewhat easy, but as usual i think i am wrong...so here it goes:

I’m trying to create a bar chart kind of like a battlefield or chess set. Envision this:

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>Each troop/chess piece can move only horizontal and has a range. For example, Team A moves from left to right and Team B moves from Right to left (like a chess match or a battlefield)

TEAM A:

In cells A2:A4 is the name of each troop in Team A
In Cells B2:B4 is the amount of spaces each Team A troop can move that round

In Cells C2:C4 is the range of each Team A troop (range is range of attack..for example a archer can say move 2 spaces, but then shoot 5 additional spaces—range is the 5 additional spaces)

<o></o>
TEAM B:

In cells A5:A7 is the name of each troop in Team B
In Cells B5:B7 is the amount of spaces each Team B troop can move that round
In Cells C5:C7 is the range of each Team B troop.

<o></o>I would like the chart to have the troop name on the two Y-axis’ with the x-axis going from 0-5200. Team A starts at point zero and Team B starts at point 5200. They move towards each other like a battler or chess match. So the troops listed on each Y-Axis converge on each other—a bar chart where the bars move towards each other. Eventually I would like other stats in the graph, but I think I may be able to figure that out later. Right now I cannot figure out how to get them to converge on each other or even get the two y-axis setup.

Fyi—I would like them to face each other so that the warriors of Team A line up with the warriors of Team B. The movement of the two will never overlap, but their ranges could. I would like the overlap of their ranges colored a different color, but that is only after I figure out how to get the above setup right. EACH TROOP WOULD HAVE TWO BARS (ONE FOR MOVEMENT AND ONE FOR RANGE)—SORRY FOR THE CAPS, BUT I DIDN’T POINT THAT OUT EARLIER.

<o></o>
Please let me know if I haven’t explained myself and I’ll try to make it clearer…I’ve attached some data so you can see what I’m talking about.

<o></o>
Thank you very much
Darius


Sheet2

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Troop</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Movement</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Range</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Warriors</TD><TD style="TEXT-ALIGN: right">50</TD><TD style="TEXT-ALIGN: right">25</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Archers</TD><TD style="TEXT-ALIGN: right">85</TD><TD style="TEXT-ALIGN: right">50</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Cavarly</TD><TD style="TEXT-ALIGN: right">100</TD><TD style="TEXT-ALIGN: right">35</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>Warriors</TD><TD style="TEXT-ALIGN: right">5150</TD><TD style="TEXT-ALIGN: right">5125</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD>Archers</TD><TD style="TEXT-ALIGN: right">5115</TD><TD style="TEXT-ALIGN: right">5065</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD>Cavarly</TD><TD style="TEXT-ALIGN: right">5100</TD><TD style="TEXT-ALIGN: right">5065</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[dariushou]

anyone? I really need to be able to do this in one chart as i can't imagine having to resize 200 charts when they out of allignment.

if not is there a company or individual that does this sort of thing for a fee? I've spent 100s of hrs trying to figure it out.

Thanks Again,

Darius