software

I would like to create a chart that shows information for one year from 2
different companies and then show the difference between the 2. Show January
2004 for Company A and show January 2004 for Company B and then show the
difference. Is this possible ? I can't figure it out even after referring to
this link I got off another post.
processtrends.com/pg_charts_D...comparison.htm
Thank you in advance,
Debra

Debra:
What you want to do is possible.

1. We need to set up our data table. I suggest that you make four columns:

Column_1 Column_2 Column_3 Column_4
Date Comp#1 Comp#2 Dif(1-2)

1/15/05 123456 123450 6

I'd use the mid date of month for charting purposes.

2. Next we want to create a chart. I prefer use XY (Scatter), you can use
either XY or Line Chart, your choice.

While there are several ways to do this, I'll walk you through XY Scatter.

a. Select your entire data table, including title row.
b. Press Chart icon
c. Select chart type - try XY scatter. you can change to line latter if you
like
d.You'll be given several chart format and chart location prompts. You can
format or go back later. Keep hitting next until you are at Finish.

You should have your standard Excel chart with legend and your column titles
in legend.

3. You should now be able to format the chart the way you want.

....Kelly
quot;Debraquot; gt; wrote in message
...
gt;I would like to create a chart that shows information for one year from 2
gt; different companies and then show the difference between the 2. Show
gt; January
gt; 2004 for Company A and show January 2004 for Company B and then show the
gt; difference. Is this possible ? I can't figure it out even after referring
gt; to
gt; this link I got off another post.
gt; processtrends.com/pg_charts_D...comparison.htm
gt; Thank you in advance,
gt; Debra
Kelly,
Thank you so much. I will try this and post back my results. It will
probably be tomorrow.
Thank you,
Debra

quot;Kelly O'Dayquot; wrote:

gt; Debra:
gt; What you want to do is possible.
gt;
gt; 1. We need to set up our data table. I suggest that you make four columns:
gt;
gt; Column_1 Column_2 Column_3 Column_4
gt; Date Comp#1 Comp#2 Dif(1-2)
gt;
gt; 1/15/05 123456 123450 6
gt;
gt; I'd use the mid date of month for charting purposes.
gt;
gt; 2. Next we want to create a chart. I prefer use XY (Scatter), you can use
gt; either XY or Line Chart, your choice.
gt;
gt; While there are several ways to do this, I'll walk you through XY Scatter.
gt;
gt; a. Select your entire data table, including title row.
gt; b. Press Chart icon
gt; c. Select chart type - try XY scatter. you can change to line latter if you
gt; like
gt; d.You'll be given several chart format and chart location prompts. You can
gt; format or go back later. Keep hitting next until you are at Finish.
gt;
gt; You should have your standard Excel chart with legend and your column titles
gt; in legend.
gt;
gt; 3. You should now be able to format the chart the way you want.
gt;
gt; ....Kelly
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;Debraquot; gt; wrote in message
gt; ...
gt; gt;I would like to create a chart that shows information for one year from 2
gt; gt; different companies and then show the difference between the 2. Show
gt; gt; January
gt; gt; 2004 for Company A and show January 2004 for Company B and then show the
gt; gt; difference. Is this possible ? I can't figure it out even after referring
gt; gt; to
gt; gt; this link I got off another post.
gt; gt; processtrends.com/pg_charts_D...comparison.htm
gt; gt; Thank you in advance,
gt; gt; Debra
gt;
gt;
gt;

Kelly, It worked great. Thank you so much for your help. I really appreciate
it.
Regards,
Debra

quot;Kelly O'Dayquot; wrote:

gt; Debra:
gt; What you want to do is possible.
gt;
gt; 1. We need to set up our data table. I suggest that you make four columns:
gt;
gt; Column_1 Column_2 Column_3 Column_4
gt; Date Comp#1 Comp#2 Dif(1-2)
gt;
gt; 1/15/05 123456 123450 6
gt;
gt; I'd use the mid date of month for charting purposes.
gt;
gt; 2. Next we want to create a chart. I prefer use XY (Scatter), you can use
gt; either XY or Line Chart, your choice.
gt;
gt; While there are several ways to do this, I'll walk you through XY Scatter.
gt;
gt; a. Select your entire data table, including title row.
gt; b. Press Chart icon
gt; c. Select chart type - try XY scatter. you can change to line latter if you
gt; like
gt; d.You'll be given several chart format and chart location prompts. You can
gt; format or go back later. Keep hitting next until you are at Finish.
gt;
gt; You should have your standard Excel chart with legend and your column titles
gt; in legend.
gt;
gt; 3. You should now be able to format the chart the way you want.
gt;
gt; ....Kelly
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt; quot;Debraquot; gt; wrote in message
gt; ...
gt; gt;I would like to create a chart that shows information for one year from 2
gt; gt; different companies and then show the difference between the 2. Show
gt; gt; January
gt; gt; 2004 for Company A and show January 2004 for Company B and then show the
gt; gt; difference. Is this possible ? I can't figure it out even after referring
gt; gt; to
gt; gt; this link I got off another post.
gt; gt; processtrends.com/pg_charts_D...comparison.htm
gt; gt; Thank you in advance,
gt; gt; Debra
gt;
gt;
gt;