Excel Help

[The Boosh!]

Right im trying to make a bar chart on excel which brings together two seperate tables. to do it i highlight one chart, click the appropriate table, then i click select range and then select the second table... Iv tried a number of ways of doing it but i can't seam to display these two seperate tables on one graph... help!? Oh and i am on the older version of excel!

 

[The Boosh!]

Bump!
Thought i would add a little more information... here is what im trying to do:

Basically i want a bar graph to display the above three tables (3 of them)...
on the X axis i want the words from each table.
Then on the y Axis i want 0 - 10 ( this is the amount of errors people make, for example if i were to put 10 into the "title" box, i want the graph bar thing to go up to ten etc etc).

Id be greatfullfor any help as its doing my nut in now!
Luke

 

[chris_182]

does it not work if you create a graph with just one series and use Control key while highlighting fristly all the x-axis labels and secondly all three data ranges?

 

[Rhino172]

does it not work if you create a graph with just one series and use Control key while highlighting fristly all the x-axis labels and secondly all three data ranges?

that should do the trick...that's how I've always done things like this

 

[The Boosh!]

does it not work if you create a graph with just one series and use Control key while highlighting fristly all the x-axis labels and secondly all three data ranges?

No because i need 0-25 up the y axis

 

[lewisniven]

try selecting one set, then hold ctrl, and select the other set, then hit the bar graph button

 

[The Boosh!]

^^^ doesn't work.... And it wont let me add more then 15 labels across the X axis... holding CTRL etc doesn't work

 

[MarkCup]

No because i need 0-25 up the y axis

Like this?

I just created a random set of values against the 25 different ranges and clicked chart wizard, bar chart and that's what it gave me.

That's using Excel 2000 Professional - I'm surprised you can't get 25 ranges on the X-axis out of a later version of Excel?

 

[The Boosh!]

^ exactly like that mark!

How exactly did you do it?

I think mine is f**king up because there are three seperate tables