Charts and Line Graphs comparing companies with different data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a chart that is a line graph in Excel 2000. I want to
compare severao builders price and square feet with each company being a
different color.
Here is an example Company A has homes that are 2152 square feet at
$162000, 2424 square feet at $169000, and 2691 square feet at $178000.
Company B has homes that are 2095 square feet at $159000, 2292 square feet at
$164000, and 2436 square feet at $173000. There will probably be Companys c
thru H as well with different data. Can you help? I have searched the web
and all this is greek to me - I need it to be in the simplest terms possible
please!
Thank you!
 
Put company A's data into columns A and B like this:

Company A
2152 162000
2424 169000
2691 178000

The top left cell in this region should be blank. Select this rectangular
data range, including the blank cell and "Company A" label at the top, and
use the chart wizard to create an XY chart of this data, using markers with
lines. Each additional company's data should be arranged the same way. It's
probably best to put Company B into columns C and D, Company C into columns
E and F, etc. To add another company's data to the chart, select and copy
the data, including the blank cell and "Company X" label at the top. Select
the chart, and use Paste Special from the Edit menu to add the data as a new
series, categories in first column, series name in first row. Repeat as
needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top