Label on Excel

[Gildasl]

Hi,

I have the following set of Excel data that I would like to get on same graph.

For the sold items, I would like to use the Date as the horizontal axis.
For the milestone, I would also like to use the Date as the horizontal axis, but I want to get the label (G0, G1, G2) displayed on the graph. Currently, I have to re-edit manually all the label . Is there a trick to get the label from the table?

[TABLE="width: 810"]
<colgroup><col span="10"></colgroup><tbody>[TR]
[TD] Date
[/TD]
[TD="align: right"]9/1/2012[/TD]
[TD="align: right"]9/8/2012[/TD]
[TD="align: right"]9/15/2012[/TD]
[TD="align: right"]9/22/2012[/TD]
[TD="align: right"]9/29/2012[/TD]
[TD="align: right"]10/6/2012[/TD]
[TD="align: right"]10/13/2012[/TD]
[TD="align: right"]10/20/2012[/TD]
[TD="align: right"]10/27/2012[/TD]
[/TR]
[TR]
[TD]Milestone
[/TD]
[TD] [/TD]
[TD]G0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]G1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]G2[/TD]
[/TR]
[TR]
[TD]Sold
[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


Thanks,
Gildas

 

[Trouttrap2]

Easiest thing to do is rearrange your data. Insert the data in columns rather than in rows. Like this, in 3 columns. Notice there are no headers in the first two columns. That is becuase if you use a header Excel will think it is a series and graph it. Simply highlight the table including the blank columns and insert chart.
[TABLE="width: 211"]
<TBODY>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Sold</SPAN>[/TD]
[/TR]
[TR]
[TD]G0</SPAN>[/TD]
[TD="align: right"]9/1/2012</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]9/8/2012</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]9/15/2012</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD]G1</SPAN>[/TD]
[TD="align: right"]9/22/2012</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]9/29/2012</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]10/6/2012</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD]G2</SPAN>[/TD]
[TD="align: right"]10/13/2012</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]10/20/2012</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]10/27/2012</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL></COLGROUP>[/TABLE]

 

[jasmith4]

Select from the word Date to the final 2 under G2. Then insert a column or bar chart. That way Excel makes a lot of decisions for you based on the selection.

Trouttrap2, this works whether you transpose the chart or not.

 

[Gildasl]

Jasmith4,

Could you elaborate a bit more?
Let's say I have already a graph with the sold items and the date displayed horizontally. Then from there how to add the Milestone?
Your previous suggestion is creating one more graph .

Thanks,
Gildas

 

[jasmith4]

When you select the chart, you should see purple, blue and green boxes around the data and headings. Whichever one is surrounding the list of dates, expand it to include also the list of milestones. To expand it, grab the lower-right corner and pull it down one row.

 

[Gildasl]

Is there a way I could e-mail you my example file. For now, on the graph I see Jan-00 instead of Go