Need help -- Excel

[Hawkmoon]

I'm trying to graph two sets of numbers, and it ain't working. I hope someone can steer me in the right direction.

Column A is dates. Columns B and C are numbers associated with those dates. If I highlight (select) only column A and column B and then click on Insert --> Chart --> Column ... I get exactly what I expect to see: a line of vertical columns marching across my graph.

However, if I initially select columns A, B, and C and then do the same thing, the resulting graph is just a total mess.

What I want is to display the numbers for two columns for each date in the graph. How do I get there?

[MechAg94]

You could try graphing A&B then adding C as an additional series.  

It seems to me you ought to be able to go into the graph settings and designate X and Y axis columns. 

[Hawkmoon]

How do I add C to a graph of A and B? When I go to the screen to fine tune the axes, I can only enter values for X and Y. There are additional boxes, but they are grayed out and I can't enter anything in them.

I admit, I have trouble with Excel. I was a whiz with Quattro Pro, and QP's graphing even twenty-five years ago was light years ahead of where Excel is today.

[dogmush]

I got what I *think* you are looking for by highlighting all three columns and then going insert->chart->clustered column.  The clustered column tells excel that you want two series from the data.

See screenshot.

[Hawkmoon]

"Clustered Column"

Sounds good, I'll try it. Thank you.

...

No good. Turns out that was what I tried first, and it didn't work any better the second time than it did the first time.

[Hawkmoon]

I think I got it. I had it set up to use an "IF" operator so if there was no entry in column B, nothing would display in column C. I tried it without that IF operator, and it display correctly.

That creates some other issues, but you got me started in what I hope is the correct direction. Thanks again.