Hi,
I have a question here and can't seem to find the answer to. I'm
relatively new to excel charting and I have the following type of
chart I want to create based on the data seen below:

Time	Value	Line
1	20	a1
2	50	a1
3	40	a1
4	30	a1
5	50	a1
1	10	a2
2	30	a2
3	20	a2
4	10	a2
5	10	a2

Graph example:

60          (a1)
50    ^    /
40   /  \ /
30  / ^  v
20 - /  \_
10 _/     \_____ (a2)
   1  2  3  4  5


I want the chart to plot 2 lines (for a1, and a2, these two lines
should show up in the legend). They should be plotted next to each
other based on their respective data points.
The x-axis should contain the times (1-5) and the y-axis should
contain the values (range 10-60).

I want the graph to show up with the two lines showing their
individual data over the 1-5 time period. I can't figure out how to do
this in excel, or whether I need to write code to model the data
differently so it can be graphed.

If anyone has an idea it would be greatly appreciated.

Thanks,
David

This is a repost of http://answers.google.com/answers/main?cmd=threadview&id=136245

-THV

The data has to be modeled as following:

1	20	10
2	50	30
3	40	20
4	30	10
5	50	10

Highlight A1:C5, Click on Chart Wizzard and choose your graph type. 
If applicable you can then manipulate chart options by right clicking
on chart object.  From within this interface you can add Category Axes
Labels etc. for certain types of charts.